Page 1 of 1

How to send data From Code to StoredProcedure ?

Posted: Wed 01 Feb 2006 14:55
by haci
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.

Posted: Mon 06 Feb 2006 11:59
by Ikar
You can use something like this

Code: Select all

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