?
Solved

ado with parameters

Posted on 2002-05-11
8
Medium Priority
?
284 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
[X]
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
  • 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 150 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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

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…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Suggested Courses

771 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