Joost van der Sluis wrote:
Op maandag 12-01-2009 om 13:30 uur [tijdzone -0500], schreef David B
Copeland:
"Query: Cannot open a non-select statement"
'show tables' is not a valid sql-statement. It is a MySQL-hack. The
TODBCConnection can not see that it is connected to a MySQL server and
thus doesn't recognise this statement as a select-statement. If you use
a TMySQLConnection it will work. You can fill in a bug report to ask if
TODBCConnection can recognise 'show' as 'select'. We'll have to look
what kind of effect that has on other (really sql-based)
database-servers.
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|/'
_______________________________________________
fpc-pascal maillist - fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-pascal
