Can execute() return both recordset and output parameters
Database
2
Posts
2
Posters
0
Views
1
Watching
-
I using ADO to execute a stored procedure that will return a recordset and some parameters, but if I get the recordset will cause output parameters to be empty. rs = cmd->Execute( NULL, NULL, NULL ); otherwise, I remove rs then the output parameters will be right. cmd->Execute( NULL, NULL, NULL ); any idea?
-
I using ADO to execute a stored procedure that will return a recordset and some parameters, but if I get the recordset will cause output parameters to be empty. rs = cmd->Execute( NULL, NULL, NULL ); otherwise, I remove rs then the output parameters will be right. cmd->Execute( NULL, NULL, NULL ); any idea?
For SQL-Server, the output parameters are only available after you have closed the recordset.