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.
tia,
--Mike
--
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software Architect
http://mbsoftwaresolutions.com
http://fabmate.com
http://twitter.com/mbabcock16
_______________________________________________
Post Messages to: ProFox@leafe.com
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/50fec468.7000...@mbsoftwaresolutions.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.