BorlandTalk.com

Guest

I'm using D6 and MSSQL 2000.

I have a stored procedure on the database server:

create procedure myTest
@id int output
as
select @id=123456

My client is using a TADOQuery to execute the procedure.
In code, I set the SQL property to

'exec myTest @id=:id'

and then I seem to have a parameter created, whose value I set.
However, after invoking the method

ADOQuery1.ExecSQL;

the parameter value seems unchanged.

Is there some way of getting the updated value?

Could anyone tell me what the technique is?

Thanks,
Richard