[fpc-pascal] SQL show tables

Joost van der Sluis joost at cnoc.nl
Tue Jan 13 10:03:34 CET 2009


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.

btw: To get the list of tables, you can better use
TSQLConnection.GetTableNames.

Joost.





More information about the fpc-pascal mailing list