That was someone else's suggestion in the thread I believe. Otherwise you get the result of a query in a cursor and process the cursor. Since working with tables is so fundamental to VFP it would be and is a good enough solution for me. We'll see if Mr. Babcock wants to get all fancy... :-)
-- rk -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Stephen Russell Sent: Friday, January 17, 2014 10:40 AM To: [email protected] Subject: Re: Getting answer values from MySQL stored procedures >From the MSDN web: * Create temp stored procedure with OUTPUT parameter and call it. SQLEXEC(m.lnConn, "CREATE PROCEDURE #MyProc @outparam int OUTPUT AS; SELECT @outparam=100") SQLEXEC(m.lnConn, "exec #myProc ?@lnOutput") ? m.lnOutput * Create a temp stored procedure with INPUT and OUTPUT parameters * and call it. SQLEXEC(m.lnConn, "CREATE PROCEDURE #MyProc2 " + ; "@inputparam INT, " + ; "@outparam int OUTPUT " + ; "AS SET @outparam=@inputparam*10") SQLEXEC(m.lnConn, "exec #myProc2 ?lnPercent, ?@lnOutput") ? m.lnOutput Thus you can make your sprocs and publish from VFP. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/DF1EEF11E586A64FB54A97F22A8BD04422A3144EDB@ACKBWDDQH1.artfact.local ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
