How to send data From Code to StoredProcedure ?

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
haci
Posts: 11
Joined: Tue 17 Jan 2006 11:32

How to send data From Code to StoredProcedure ?

Post by haci » Wed 01 Feb 2006 14:55

I create stored procedure in sql server called "SDAC_UpdateRec",and i call with MSStoredProc1. it's parameters are @NUM1 int, @PKEY int.

Component Name is MSStoredProc1. How to set datas to these parameters from Delphi code ?

Thank you.

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Mon 06 Feb 2006 11:59

You can use something like this

Code: Select all

MSStoredProc1.ParamByname('NUM1').AsInteger := 1

Post Reply