when can use UniQuery call Procedure,for example:
Code: Select all
UniQuery.Sql.text:='begin proc1(:a,:b,:c) end';
UniQuery.params[0].datatype:=ftString;
.....
UniQuery.execute;
but i find that UniQuery can not call Procedure In sqlserver;
for exmaple :
Code: Select all
UniQuery.Sql.text:=
'{:RETURN_VALUE = CALL GETAffiMsg (:PICK, :TaskContNo, :Msg)}';
....
UniQuery.execute
we Must use UniStoredPorc in sqlserver;
i think UniQuery can instead of UniStoredPorc ;
can you give me a demo fro UniQuery instead of UniStoredPorc in mssql?