Solved

Arabic Application Development in VB6

Posted on 2004-08-12
10
1,650 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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
 
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.
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 …
Six Sigma Control Plans

688 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