See non commited data

calou · Post by **calou** » Mon 21 Mar 2011 17:16

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

tsteinmaurer · Post by **tsteinmaurer** » Mon 21 Mar 2011 19:14

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.

AndreyZ · Post by **AndreyZ** » Tue 22 Mar 2011 09:57

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.

calou · Post by **calou** » Tue 22 Mar 2011 10:44

Thanks for help

AndreyZ · Post by **AndreyZ** » Tue 22 Mar 2011 11:44

Feel free to contact us if you have any further questions about IBDAC.