Subject RE: [firebird-support] firebird and transaction behaviour questions
Author Zoran



From: []
Sent: Tuesday, February 23, 2016 10:15 AM
Subject: Re: [firebird-support] firebird and transaction behaviour questions




>>> That's true, but according to ODBC specs driver should start transaction automatically as needed.

>>> Is this the case if you are doing reads only?

>>> Yes.

>>Why would you use transaction for select statements?

>To isolate statements from uncommitted changes.



Hi Alexey

I am not a Firebird expert by any means, but how you get uncommitted data in your select statement? I tried to read your article, but it is still unclear to me…

If other clients use transactions to update database, how is it possible to get uncommitted data when I run a select statement?