It's pretty close3 to that. -1 means the query failed to run. 1 means it ran without error although that's no guarantee you got any results. I think mb was trying to figure out if he could directly get the return value from the query. With VFP SQL you can return results into an array but that's not the case when using external databases. So he just has to live with the overhead of the presumably in-memory cursor.
-- rk -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Stephen Russell Sent: Thursday, January 16, 2014 2:15 PM To: [email protected] Subject: Re: Getting answer values from MySQL stored procedures On Thu, Jan 16, 2014 at 12:30 PM, Richard Kaye <[email protected]> wrote: > AFAIK SQLEXEC in VFP will always an integer value that indicates if > the command was executed successfully. Any result set will end up in a > VFP cursor. > ----------- Well tried to come up with an idea. It is just Bool value to to check. Oh well. _______________________________________________ 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/DF1EEF11E586A64FB54A97F22A8BD04422A3144C66@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.
