Interbase Database Corruption ?

[StevenK]

We're getting a Rollback on a transaction against an INSERT into an Interbase table through Delphi code.
We're suspecting that the fault lies in a corrupt database. We are currently unable to see the database so are guessing here.
Is it possible for just one table to become corrupt or is the database as a whole at fault ? Entries can be INSERT'ed into other tables with no errors.
The data in the table can still be SELECT'ed from - or else the customer would have mentioned it. May the problem lie in the INSERT action against the table itself. The code being run has been in place for 18 months plus with no such problem.
Can anyone indicate whether a corruption may be specific to an INSERT into a single table ?
Steve.

 

[Guest_imported]

Hello,
I think the problem is that interbase tables can only have 2 GB maximum size. I don't know if this is your problem...
I try some months ago insert lots of records into a table,
then when she beats the maximum size, became corrupt.
I don't remember if it interbase of borland or firebird.
Maximum database size is 4 GB.
If you use multiple files, than database can grow.

Correct me if I am wrong.