It Could be the configuration you are using on your connection string That sometimes is the cause of odd mysql results. Bob Lee
-----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of MB Software Solutions, LLC Sent: Tuesday, January 22, 2013 12:42 PM To: [email protected] Subject: Re: MySQL SHOW WARNINGS equivalent (called from VFP) On 1/22/2013 12:19 PM, Stephen Russell wrote: > On Tue, Jan 22, 2013 at 10:55 AM, MB Software Solutions, LLC < > [email protected]> wrote: > >> VFP9SP2 SPT to MySQL (actually MariaDB) backend >> >> I'm writing some code to do lots of data work and after certain >> things I want to check the warnings, the equivalent of returning what >> SHOW WARNINGS shows in the HeidiSQL IDE. VFP though doesn't bring >> back a nice structure, so the cursor's return contents are useless. >> Is there something in the information_schema or otherwise current db >> that I could query to get this info? Surely there is. After all, instead of SHOW TABLES I can SELECT * >> FROM information_schema.`tables` There just doesn't seem to be an >> equivalent. Plus, SHOW TABLES returns something I can use; SHOW >> WARNINGS does not. (Well, it returns rows with LEVEL and CODE >> values, but the MESSAGE field is just encrypted/jumbled crap. >> >> I had been doing this job manually in the HeidiSQL IDE but I'm trying >> to automate it now from VFP. > > > ------------------------------- >> > > Isn't that part of the connection/execute and not part of the return > dataset? > You're thinking of the return value of SQLEXEC...that's not what I'm talking about. I'm talking about the dataset returned from this: SQLEXEC(liHandle,[SHOW TABLES],'curTables') SQLEXEC(liHandle,[SHOW WARNINGS],'curWarnings') -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 [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/00e101cdf8de$398cf660$aca6e320$@com ** 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.
