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? -- Dr. Richard E. Hawkins, Esq. (702) 508-8462 _______________________________________________ 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