ADO: Output Parameter value from Stored Proc Recordset Results

[bjgolden80]

ADO: Output Parameter value from Stored Proc Recordset Results

Hi,

I am working with ADO to retrieve recordsets from SYBASE using stored procedures. The stored procedures also return an output parameter.

The problem I am having is that the value of the output parameter is not being exposed until after the recordset is cycled through and closed, however I need the output parameter value to handle the recordset as I loop through it. This used to work fine with RDO but not with ADO for some reason.

Any ideas on work arounds or fixes?

thanks,
Barry

---------------------

 

[PatrickIRL]

Do you get the value if you just do a movelast and then movefirst????

Patrick