My Stored procedure makes 6 different queries to pass the filtering test and if any one of them fail, I need to return an appropriate message to the front end, else if it succeeds then I need to return the recordset for furthur processing in the front end.
I, presently have an Output parameter (ADODB.Command using the Execute method) to get the values of the status where the filter failed but when it succeeds, how do I get the recordset? Do I need run the Stored Proc(ADODB.recordset and OPEN method) a second time to get the recordset?
Thanks for you help in advance.
I, presently have an Output parameter (ADODB.Command using the Execute method) to get the values of the status where the filter failed but when it succeeds, how do I get the recordset? Do I need run the Stored Proc(ADODB.recordset and OPEN method) a second time to get the recordset?
Thanks for you help in advance.
