Search found 4 matches

by avatar
04.09.2013, 07:09
Forum: MySQL
Topic: Clone Recordsets
Replies: 0
Views: 2132

Clone Recordsets

Anybody know if there is a quick way to clone recordsets in zeoslib (for mysql) similar to ADO?
by avatar
27.05.2010, 12:02
Forum: MySQL
Topic: How to enumerate tables based on a selected database
Replies: 4
Views: 889

@mdaems: thanks for the tip that would really be useful for my next debugging session. Anyway it seems I have to add an additional parameter to the GetTableNames method... ZConn.GetTablesNames('',lstTables) should be ZConn.GetTablesNames(ZConn.GetTableNames('%',ZConn.Database,lsTables); I assumed th...
by avatar
24.05.2010, 02:27
Forum: MySQL
Topic: How to enumerate tables based on a selected database
Replies: 4
Views: 889

still can't make GetTablesNames to work right but in case anyone has the same problem as mine, I made a workaround by running the following query SELECT table_name FROM information_schema.tables WHERE table_schema='<database taken from GetCatalogNames() result>' not a portable code i'm afraid but wo...
by avatar
23.05.2010, 11:57
Forum: MySQL
Topic: How to enumerate tables based on a selected database
Replies: 4
Views: 889

How to enumerate tables based on a selected database

Hi, I'm starting a new project that provides a way for the user to customize which databases or table to work on...IIRC i should be able to enumerate the databases via the GetCatalogNames method of TZConnection and GetTablesNames method for the tables. However it seems that only GetCatalogNames work...