Hi,

I read in the "Firebird Book" about transactions and it looks like
certain fine tuning is not possible with dbExpress/Firebird. So here
are my remaining questions:

- Is it correct, that transactions should be as short as possible? So
best is just a transaction for each statement? (except for bulk
insert/update)

- Should I use READONLY READCOMMITTED transactions for SELECT
statements where ever possible? (because of OIT/OAT)

- I think IsolationLevel xilREPEATABLEREAD corresponds to SNAPSHOT in
Firebird?

- How can I set the transaction to READONLY ?

- Where and whant kind of transaction is started, if I don't call
StartTransaction? With a SELECT Statement ? With INSERT/UPDATE/DELETE
Statement?

When I look at the code in SqlExpr.pas, the property InTransaction
doesn't reflect the real value of the transaction. I suppose, this is
handled in the dbExpress driver (Upscene), so Martijn will know the
details here? Did I miss any documentation about that?

cu Christian