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
Solved

Arabic Application Development in VB6

Posted on 2004-08-12
10
1,603 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
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
groupSum6 challenge 6 101
tvirtualstringtree freeze when load too manny images 10 71
youtube blocking politics 4 55
Where to download python requests library 6 25
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
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.

840 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