Firebird/Interbase Database Indexes
Posted on 2006-11-02
I have a firebird database which having a table well indexed, eg unique index transactionnumber. However after some times, I find that I am able to save the record with the same transactionnumber twice. Finally when I look into this database, I find this unique index is somehow inactive.
Do anyone know what may cause this happen whereas I do not do anything to inactivate this index ?