ado with parameters

hi all:
i want to know how can pass parameters from store proceduer and  delphi ( for example insert record using store procedure and this records values come from edit1 and edit2....etc)and when i press button these edits go to parameters in store procedure!!!!!!
also i have small broblem  in delphi six i can't writing arabic language in editor of delphi ( for example in procedure showmessage(' ') i want to write arabic!!!!
so how can i solve these problems???????
regards....
omer alfaroug
omeralfarougAsked:
Who is Participating?
 
MotazConnect With a Mentor Commented:
2. It seems that you are using Win2000, if so then:
- Open settings/Control Panel/Regional settings
- In General tap/Click Advanced button
- Check all unchecked Arabic fonts
- Reboot Windows

I hope this helps
Motaz
0
 
MotazCommented:
Hi Omer,
1.

AdoStoredProc1.Parameters.Refresh;
AdoStoredProc1.Parameters.ParamByName('@Name').Value:= Edit1.Text;
AdoStoredProc1.Parameters.ParamByName('@Address').Value:= Edit2.Text;
AdoStoredProc1.ExecProc;

To be continued..
0
 
omeralfarougAuthor Commented:
Hi Azzoz,
thanks for help stored procedure now work but when store data into table then just one character saved (for example adding "Azzo" but inserted "A" only !!!!!)my header in SP is
(@name varchar)????Also i want to ask is if i drag 2SP and 2 AdoQuery and Table is that mean for every one i must drag AdoConnection???i want just one Adoconnection for All!!!is this in run time???
Lastly which is better AdoQuery or AdoTable For working with SQLServer DB??? (i know that u need to increasing points of this question :-)but till now i haven't salary:)
About writing Arabic in Delphi i used win2000 but all fonts are checked in regional but no response dosn't work why??????
thanks and remember if u work with me may be u will be the first expert i have more points :-)
regards...
omer alfaroug
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
omeralfarougAuthor Commented:
Hi Azzoz,
thanks for help stored procedure now work but when store data into table then just one character saved (for example adding "Azzo" but inserted "A" only !!!!!)my header in SP is
(@name varchar)????Also i want to ask is if i drag 2SP and 2 AdoQuery and Table is that mean for every one i must drag AdoConnection???i want just one Adoconnection for All!!!is this in run time???
Lastly which is better AdoQuery or AdoTable For working with SQLServer DB??? (i know that u need to increasing points of this question :-)but till now i haven't salary:)
About writing Arabic in Delphi i used win2000 but all fonts are checked in regional but no response dosn't work why??????
thanks and remember if u work with me may be u will be the first expert i have more points :-)
regards...
omer alfaroug
0
 
MotazCommented:
Hi omer
use @Name VarChar(100) instead of only VarChar..
I'll be back..
0
 
MotazCommented:
About the second question (AdoConnection):
you can use only one AdoConnection and Assign it in all the data sets (AdoQuery, AdoTable, AdoStore...) there is a property called Connection, you can select AdoConnection1 at design time, AdoConnection is useful also for preventing login prompting (Turn login prompt to False) after saving login name and password in ConnectionString.

About windows 2000 Arabic fonts, actually that was the only solution I know, Ali Elmahi know the rest of solution, but he ask for points:)

Motaz
0
 
MotazCommented:
About Queries vs Tables,
in Client server databases, always the tables has a very big size, so that you cann't display all the records usign Table component, instead you can only display small part of it using Query depending on user query.
Tables is used only with lookup and small tables, queries can be used with all, but don't display very large data in queries because it will take long time.

Motaz
0
 
gaafer5Commented:
íÇ ÈáíÏ
adostoredproc.prepare;
adostoreproc.parameters.parambynam('@x').value:=edit1.text;
adostoreproc.open;
íÇÎ ÇäÊ ßÚÈ
ãÍãÏ ÌÚÝÑ
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.