Stored Procedure Calling

HotRod40

Delphi Developer

Stored Procedure Calling

2004-05-26 09:05:26 PM
delphi260
Hi,
Could anyone show or describe how to call and execute a SQL Server 2000
stored procedure in Delphi 5 Prof. that using the TStoredProc component in
D5. I dont have ADO as it doesnt come with D5 as standard.
Any help or suggestions would be appreciated.
Scott

Brian Hollister

Delphi Developer

2004-05-26 09:37:16 PM

Re:Stored Procedure Calling

"HotRod40" <XXXX@XXXXX.COM>writes

Quote

Hi,

Could anyone show or describe how to call and execute a SQL Server 2000
stored procedure in Delphi 5 Prof. that using the TStoredProc component in
D5. I dont have ADO as it doesnt come with D5 as standard.

Any help or suggestions would be appreciated.
Scott

Goto the help files and on the Index tab, search for TStoredProc.

At the top of the help file click Methods, look for ExecProc. It has an
example right there.
hth,
b

Jeremy Collins

Delphi Developer

2004-05-27 12:09:53 AM

Re:Stored Procedure Calling

HotRod40 writes:

Quote

Hi,

Could anyone show or describe how to call and execute a SQL Server 2000
stored procedure in Delphi 5 Prof. that using the TStoredProc component in
D5. I dont have ADO as it doesnt come with D5 as standard.

Any help or suggestions would be appreciated.
All computers have ADO (if you install it). In Delphi, go

to Project | Import Type Library and import the MS ActiveX
Data Objects 2.x Library.
You'll have a file called "ADODB_TLB.PAS". You can now create
Connection and Command objects and execute your stored
procedure.
I can provide an example if you want to go this route.
--
jc
Remove the -not from email