Raised This Month: $ Target: $400
 0% 

[SQL] Calling stored procedures which return a result set


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Podunk
Senior Member
Join Date: Nov 2005
Location: Florida
Old 09-22-2007 , 19:39   Re: [SQL] Calling stored procedures which return a result set
Reply With Quote #2

I'm having the same problem

Quote:
[22 Nov 2006 12:44] Tonci Grgin
Hi Frank and thanks for helping us on MySQL connector/ODBC v5.

This is not a bug but correct and documented behavior:
If you write C programs that execute stored procedures with the CALL SQL statement, you
must set the CLIENT_MULTI_RESULTS flag when you call mysql_real_connect(), either
explicitly, or implicitly by setting CLIENT_MULTI_STATEMENTS. This is because each CALL
returns a result to indicate the call status, in addition to any results sets that might
be returned by statements executed within the procedure. To process the result of a CALL
statement, use a loop that calls mysql_next_result() to determine whether there are more
results. For an example, see Section 22.2.9, “C API Handling of Multiple Statement
Execution”.


ahh: http://bugs.alliedmods.net/index.php...ls&task_id=281
__________________
Check out my website at http://matthewmiller.info

Last edited by Podunk; 09-22-2007 at 19:47.
Podunk is offline
Send a message via MSN to Podunk
 



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 06:33.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode