Board index » delphi » Output parameter in stored proc. using ADO
MiB
Delphi Developer |
Fri, 16 Feb 2001 03:00:00 GMT
Output parameter in stored proc. using ADO
I have imported ADO typelib to use it for invoking stored procedure in MSSQL
server. The procedure has output parameter which is correctly returned to me under ISQL. Following is the code to do this in Delphi. The problem is : I cannot get back output value(in the code variable id is always 0). What I am doing wrong? //--Procedure declaration CREATE PROC prProcName(@str varchar(100), @id int OUTPUT) AS //------------- input := pCommand.CreateParameter('@str', pCommand.Get_Parameters.Append(input); V := VarArrayOf(['test',10]); |