Page 1 of 1

See non commited data

Posted: Mon 21 Mar 2011 17:16
by calou
hello,

With one query i do a delete in a table and i execute the method (but i don't commit).
Is it possible for an other query to "see" the new data even if they are not commited?
I try to look at the isolationlevel property but i am not sure if it is possible.

Thanks for help

Regards

Posted: Mon 21 Mar 2011 19:14
by tsteinmaurer
If the other query uses the same transaction, then yes, it will see the changes. If it is another transaction then no. Firebird/InterBase does not support the READ UNCOMMITTED isolation level.

Posted: Tue 22 Mar 2011 09:57
by AndreyZ
Hello,

Thank you, tsteinmaurer, for your help.
It's true, one query can see uncommited changes made by other query only if both queries use the same transaction.

Posted: Tue 22 Mar 2011 10:44
by calou
Thanks for help

Posted: Tue 22 Mar 2011 11:44
by AndreyZ
Feel free to contact us if you have any further questions about IBDAC.