RE: [firebird-support] firebird and transaction behaviour questions

Tue, 23 Feb 2016 07:48:07 -0800 

 

 

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

 

  

Hi,

>>> 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.

>http://www.slideshare.net/ibsurgeon/3-how-transactionswork

 

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?

Regards

Zoran

Reply via email to