IBTransaction and transaction isolation.

[Steve]

Using C++Builder 5 and Interbase 7.1 SP 2


I am slowly moving my components from the BDE to IBX. I have a
IBDatabase component with a default IBTransaction. On individual forms
I access a IBQuery but I give it a new IBTranaction component (instead
of using the default). Does this give me tranaction isolation, or do I
already have that if I just use the single default IBTransaction?

[Jeff Overcash (TeamB)]

Post by Steve
Using C++Builder 5 and Interbase 7.1 SP 2
I am slowly moving my components from the BDE to IBX. I have a
IBDatabase component with a default IBTransaction. On individual forms
I access a IBQuery but I give it a new IBTranaction component (instead
of using the default). Does this give me tranaction isolation, or do I
already have that if I just use the single default IBTransaction?

Everything that shares a transaction all have the same transaction from a read
standpoint (iow posting a record in one query can be read by another query using
the same transaction without committing). If two queries have different
transactions they are isolated from each other and can't see changes made by the
other until the other commits.

Usually each form will have at least its own transaction so committing changes
on one form would not have the side effect of committing changes made in other
forms but not ready to be committed.