Surely myVar = SQLEXEC() returns the status of the command (-1, 0, 1+), not the actual retrieved data, which will be in a VFP cursor
________________________________ From: Mike Copeland <[email protected]> To: [email protected] Sent: Thursday, 16 January 2014, 18:40 Subject: Re: Getting answer values from MySQL stored procedures +1 -------- Original Message -------- Subject: Re: Getting answer values from MySQL stored procedures From: Richard Kaye <[email protected]> To: [email protected] Date: 1/16/2014 12:30 PM > 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. > > -- > rk > > -----Original Message----- > From: ProfoxTech [mailto:[email protected]] On Behalf Of Stephen > Russell > Sent: Thursday, January 16, 2014 1:05 PM > To: [email protected] > Subject: Re: Getting answer values from MySQL stored procedures > >>> ? SQLEXEC(lnConn, lCmd) >>> >> ---------------------------------------------- > Why not try: > > MyVar = SQLEXEC(lnConn, lCmd) > > -- > Stephen Russell > > [excessive quoting removed by server] _______________________________________________ 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/[email protected] ** 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. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ 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/[email protected] ** 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.
