On several occasion I have run into a troublesome bug when creating tables that contain a large number of columns. After adding about the 260th column, I try to apply the changes and I am denied and get a firebird error. I didn’t copy it down but I think it says that changes can’t be made because too many versions exist. It then locks the table so that columns can neither be added or deleted. The only way I can get the table unlocked is to export and then import the solution with an empty database so that Servoy rebuilds the table. I am wondering if this is a bug or if I am in error by making tables with so many columns.
John McCann
Windows, Servoy 2.0 beta 4, Firebird 1.0
You are probably hitting the rowsize limit of Firebird. It has a maximum row width of 64 KB.
You can find more specs on Firebird here:
http://www.tietovayla.fi/interbase/5/te … tions.html
(the link above shows Interbase specs which are identical to firebird)
If you really need the columns migrating to a different database would be the best option. As you might or might not know it is quite probable that Servoy 2.0 will have iAnywhere ASA as the default database which will go up to 999 columns per table.
I switched from firebird 1.0 to Microsoft SQL Server 2000. The problem went away after the switch. I also note marked improvement in performance when viewing BLOBS. Wish I would have done it sooner.
I look forward to trying iAnyWhere when you begin to distribute it with Servoy. Too lazy to figure out how to configure it myself.
Thanks
John McCann