Hi
I friend of mine recently told me that you should do everything in Firebird in the context of a transaction. If you are only inserting/updating/deleting one record then surely you don't need a transaction. Or if you only do one DDL change then surely you don't need a transaction? I can understand if your transaction involves multiple records or multiple DDL changes.

I can only assume you're coming from the world of desktop databases, like Paradox or Access.

In real rdbms like Firebird, MS SQL Server, IBM DB2, Oracle, PostgreSQL etc. using a transaction for EVERY operation is mandatory. There's no way to avoid it.

On the other hand, transaction handling is smooth and powerful. See it as the proper way to do thing rather than as an unnecessary evil (it is not!).

Regards,
Kjell

-- 
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64