Solved

ado with parameters

Posted on 2002-05-11
8
280 Views
Last Modified: 2010-04-04
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
0
Comment
Question by:omeralfaroug
  • 5
  • 2
8 Comments
 
LVL 7

Expert Comment

by:Motaz
ID: 7003252
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
 
LVL 7

Accepted Solution

by:
Motaz earned 50 total points
ID: 7003256
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
 

Author Comment

by:omeralfaroug
ID: 7004134
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: 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.

 

Author Comment

by:omeralfaroug
ID: 7004152
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
 
LVL 7

Expert Comment

by:Motaz
ID: 7004322
Hi omer
use @Name VarChar(100) instead of only VarChar..
I'll be back..
0
 
LVL 7

Expert Comment

by:Motaz
ID: 7004328
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
 
LVL 7

Expert Comment

by:Motaz
ID: 7004354
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
 

Expert Comment

by:gaafer5
ID: 7004621
íÇ ÈáíÏ
adostoredproc.prepare;
adostoreproc.parameters.parambynam('@x').value:=edit1.text;
adostoreproc.open;
íÇÎ ÇäÊ ßÚÈ
ãÍãÏ ÌÚÝÑ
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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
Strange code, can use it, but i cant figure out what it does. 3 66
Intraweb download file link ? 1 153
Create a path if not exists 7 87
Firemonkey BASS_Init into a thread 17 30
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

809 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