Evrything that happens, even a read on a database must take place within the
context of a transaction start -> commit/rollback
Only use rollback if you want to undo changes that were made in a
transaction that inserted or modified data.
Otherwise use commit. Rollback can have implications re the OIT.

Regards
Paul Beach
Main Tel (UK):+44 (0) 1844 354465
Mobile: (UK): +44 (0) 7764 188603
http://www.ibphoenix.com
For all your upto date Firebird and
InterBase information