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
_______________________________________________
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.
