Op vrijdag 20-03-2009 om 22:38 uur [tijdzone +0800], schreef Funky Beast: > I've found a bug in sqldb/firebird. > Its reported here, with sample project to reproduce: > http://bugs.freepascal.org/view.php?id=13340
You are using one TSQLQuery object for all sorts of actions. Try to create a new TSQLQeury for every sql-statement you execute. See if that helps. And firebird doesn't allow sql-statements which changes the database (like alter table) within the same transaction as a select-statment. Are you sure you're not doing this? And the comparision with flamerobin and such is useless. In flamerobin you're not running this program which does a lot of strange things. Try a simple program which only does a 'select * from table' - You'll see that it will work. ie: debug your program and try to isolate the bug. Joost. _______________________________________________ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal