Solved

Arabic Application Development in VB6

Posted on 2004-08-12
10
1,579 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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Whether you’re a college noob or a soon-to-be pro, these tips are sure to help you in your journey to becoming a programming ninja and stand out from the crowd.
Computer science students often experience many of the same frustrations when going through their engineering courses. This article presents seven tips I found useful when completing a bachelors and masters degree in computing which I believe may he…
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

863 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

22 Experts available now in Live!

Get 1:1 Help Now