Stored Procedure OUTPUT

Hi Everyone,

I have a stored procedure with an OUTPUT variable in it. The stored procedure is being being executed by using an ADO recordset.

For example, recordset.Open "StoredProcedureName '" & InputVariable & "'"

I have tried to get the OUTPUT variable by using recordset.Fields("@OutputVariable") but nothing is returned even though the stored procedure seems to be executing okay.

Does anyone have an example of retrieving the OUTPUT variable using the ADO recordset as outlined above? Any help would be appreciated.

I don't think it will be possible... is there a particular reason you want to use a Recordset, rather than a Command (which is designed for parameters)?