On 07/14/2017 03:48 PM, Dr. Hawkins via use-livecode wrote:
Sometime ago, I wrote my own getTableNames() because
revDatabaseTableNames() would consistently fail to find them all.
Now, it to is filing.
It is, in essence,
*put* "SELECT table_name FROM information_schema.tables ;" \
& cr into dcmd
*put* revDataFromQuery(,cr,db,dcmd) into tabList
*return* tabList
I have another chunk of code which is now acting up:
*put* getTableNames(dhbkSrvrDb) into dhSrvTbls
*put* "dhStatTbl" into dhtbl_stat
*if* dhtbl_stat is not among the words of dhSrvTbls *then*
*put* "CREATE TABLE " & dhtbl_stat . . . blah blah blah
table dhStatTbl already exists, yet the conditional is reached. It
executes, and throws an error because this table is already there.
This is, to be mild, a brutal bug.
Might there be something I'm missing?
Just a guess, but the concept of 'word' is pretty slippery.
You might try 'true words' or make a comma-separated list and look among
the items or...
--
Mark Wieder
ahsoftw...@gmail.com
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
