MySQL Forums
Forum List  »  Connector/ODBC

using api call after calling stored procedure
Posted by: Mary Miller-Clark
Date: July 23, 2007 04:34PM

Hi,
Using ODBC 3.51.17, just downloaded today. I have a C++ application that calls a mysql stored procedure. All works as it should. Problem: Is there any ODBC API call that I can make to get the number of rows that were changed when the mysql procedure was called? Previous to using a procedure, we prepared and executed a sql statement in our code, then called the odbc api: SQLRowcount.
Otherwise, I could return the number of affected rows from the procedure, provided I can return that as an OUT parameter, along with my other OUT parameters. However, can't seem to get multiple out parameters to work.

All help/suggestions will be appreciated.

Options: ReplyQuote


Subject
Written By
Posted
using api call after calling stored procedure
July 23, 2007 04:34PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.