Solved

ado with parameters

Posted on 2002-05-11
8
279 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

777 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