Solved

ado with parameters

Posted on 2002-05-11
8
276 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
 

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
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

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…
This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

706 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now