Solved

Arabic Application Development in VB6

Posted on 2004-08-12
10
1,596 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
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
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

Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Non-recursive backtracking, using a stack 1 137
Currency Conversion? 1 87
Regular Expression Calculator Tester 2 74
Help Required 2 33
Here we come across an interesting topic of coding guidelines while designing automation test scripts. The scope of this article will not be limited to QTP but to an overall extent of using VB Scripting for automation projects. Introduction Now…
This article will show, step by step, how to integrate R code into a R Sweave document

831 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