On Tue, 2009-01-13 at 10:37 +0000, Martin Friebe wrote: > > > If you (the original poster) uses Mysql 5 or up, then "Show tables" is > not needed. Use the information-schema instead > > SELECT table_name FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = > '/|db_name|/' >
Yes, I tried this and it works, after setting TSQLQuery.UsePrimaryKeyAsKey := false since the table information_schema does not have a primary key. _______________________________________________ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal
