[fpc-pascal] SQLDB/Firebird unable to open table with more than 128 fields
Joost van der Sluis
joost at cnoc.nl
Sat Mar 21 16:12:36 CET 2009
Op vrijdag 20-03-2009 om 22:38 uur [tijdzone +0800], schreef Funky
> I've found a bug in sqldb/firebird.
> Its reported here, with sample project to reproduce:
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
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.
More information about the fpc-pascal