I have concatenated several stored procedures that do not return any result. After executing the compound command using ADO's Execute command, I need to check if each of the queries where executed successfully. This can be done on compound sql queries using ADO's NextRecordset method. But when I call NextRecordset on the first Recordset, I get NULL back instead of the next recordset. For non-stored procudure queries I get the next Recordset with State property of adStateClosed which is expected. Is there a way to know if a stored procedure in compound query was executed successfully?
Asked
Active
Viewed 35 times
