[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
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.





More information about the fpc-pascal mailing list