Solved

Arabic Application Development in VB6

Posted on 2004-08-12
10
1,575 Views
Last Modified: 2012-05-05
Hi all,

We need to develope an Arabic application using VB6 and Sql Server. This needs Bi - Directional Environment (BiDi) of the Windows. My problems are as follows

1. How  do i identify if the current version of Windows XP is BiDi or not.
2. If it is not BiDi then how do i convert it to BiDi.
3. After ensuring that the environment is BiDi how do i go about creating an application with arabic interface.

Thanks a lot in advance.

Sachin
0
Comment
Question by:sachinmundra
  • 5
  • 3
10 Comments
 
LVL 6

Expert Comment

by:msjammu
ID: 11784040
Can't tell about Bi - Directional Environment (BiDi) of the Windows.

But I developed a multilingual application using some technique: -

The multilingual application labels I stored in the database and depending upon the user’s selection of the language particular language labels are loaded from database and set dynamically to all the controls.

The database is designed in such a way that retrieving labels and controls are efficient.

After installing any language font (Arabic in your case) you can easily change language interface for your application

Regards,
msjammu


0
 
LVL 6

Expert Comment

by:msjammu
ID: 11784070
0
 
LVL 6

Expert Comment

by:msjammu
ID: 11784137
0
 
LVL 1

Author Comment

by:sachinmundra
ID: 11784246
Dear msjammu,

Thanks for the effort but i have already looked on the web for this information and i have gone thru more than a 500 pages on this before putting up a Question here. All the sites have the information what is bidi and how MS supports arabic application, but unfortunately that ends there and there is no explaination for the following questions.

1. How  do i identify if the current version of Windows XP is BiDi or not.
2. If it is not BiDi then how do i convert it to BiDi.
3. After ensuring that the environment is BiDi how do i go about creating an application with arabic interface. step-by-step

So please do keep looking out and i will do the same. I hope one of us comes up with a step-by-step guide to get the task accomplished.

Thanks
Sachin

PS. Form properties contains a property called RighttoLeft, if that can be made True, then our problems are solved. Same applies for all other controls also.
0
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 
LVL 1

Author Comment

by:sachinmundra
ID: 11785616
Hello Guys,

I am very happy to say that i have successfully done what is needed to create an arabic application using VB6 and Sql Server. What i have done may be specific only for Windows XP and i have done this for arabic lang only (this i suppose will apply for any RTL language) so be care full if u want to use this in ur code. The step-by-step approach for the above task can be as follows.

1. Install the language support from the Regional Settings - Arabic in this case.
2 In the advanced tab of the Regional and language options there is a language for non-unicode programs, select that to be arabic. This will need a re-start.
3. Now just start VB6 and as a test try to change the RightToLeft property of any control to TRUE. If it can be changed then CONGRATULATIONS u are ready for arabic (or any RTL) application.
4. U can change your language by pressing Alt+Shift.
5. Create a small application with 2 text boxes and 2 command buttons. Changing the font and RTL of the controls enables you to give captions in Arabic.
6. Connect to the Database using Ado.
7. The table u are going to enter data, the column data type should be nvarchar, or nchar (thats for unicode)
8. The syntax for the DML statements will contain a capital N before the quotes Examples :-
a - "insert into dummy (a,b) values (N'" & Me.Text1.Text & "'," & Text2 & ")"
b - "SELECT * FROM dUMMY where a = N'" & Me.Text1.Text & "'"


Thats it.. we are in business !!! I hope this solution will help some of you and i also hope msjammu will not mind me not giving him the points for this Question as i am CLOSING it.

Thanks and good luck anyway.
Sachin

0
 
LVL 6

Expert Comment

by:msjammu
ID: 11790658
Thank You, sachinmundra

Regards,
msjammu
0
 
LVL 6

Expert Comment

by:msjammu
ID: 12004680

Decision left to the Author,

Regards,
msjammu
0
 
LVL 1

Author Comment

by:sachinmundra
ID: 12004879
I have put up the Question and i recieve the apropriate answer i found it myself. So i have also given that in my subsequent post. I would like to withdraw the points.


Thanks
SAc
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 12038564
PAQed, with points refunded (500)

Computer101
E-E Admin
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
wordsWithout 49 80
firstChar challenge 13 86
Path of Workbook 3 45
Installed softare without GUID 6 55
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now