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