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. _______________________________________________ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal
