Subject Re: [firebird-support] # Updates a table has remaining
Author Thomas Steinmaurer
> I use FB 1.5 embedded in thousands of installations. It has worked very well--and I have a class structure (in Delphi) that I use to update the database. I have 94 updates that occur from the original installed database. Again, this has worked very well.
> I know at some point I am going to have to be checking the database tables to see how many alters I can make to a table before backing up and restring the database (something that will have to be fully automatic for my customer base).
> What is the SQL to find out how many updates are remaining per table? And does it change from 1.5 to 2.x or 3.x? (Which I could move to at the same time, but just never had a need to get there--my DB needs are fairly light).


AFAIR the limit is 255 and didn't change in V2.x.

With regards,

Thomas Steinmaurer
Upscene Productions

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!