Command Parameter Question.
Posted on 2000-04-18
If I have stored procedure that returns a value as an output parameter, that value is only stored in the command object if I use the command's .Execute method. But if I open a recordset that uses the command object for it's parameters and command, only the input parameters are passed to the procedure and the output parameter of the command object never gets filled with the output from the stored procedure.
Is it possible to return an output parameter when using the .Open method of a recordset that uses a command object as its source?