Hi

There is a limit (not particularly large) to some variable that tracks
table changes, that means that after a certain number off DDL changes to
a table the DB needs to be backed up and restored (or sweeped ???).
Others could give much better detail, but suffice to say making lots of
DDl changes to a table is not a good move in FB, you need to look for
other ways to achieve what you are wanting. Perhaps creating a
differently named table for each change would be a relatively simple
work around.

Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com

Wild Software Ltd



dandreikin wrote:

> Description: We have an application that significantly changes the
> structure of existing database using DDL commands. Each iteration
> makes some changes
> to the structure of existing tables and then puts some data to
> another table. After many iterations that could execute up to 10.000
> DDL
> commands, insert queries begin to fail constantly with such error:
> "
> invalid request BLR at offset 7
> table id 2195 is not defined
> "
>
> We use ODBC Driver version 1.2 (also problem can be reproduced with
> 2.0b ODBC FB driver.) and FB Server 2.0.3. ODBC works in autocommit
> mode.
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>