Subject | RE: [IBO] TIBOQuery.IB_TransForUpdate usage |
---|---|
Author | Support List |
Post date | 2011-06-14T20:41:12Z |
Daniel,
The purpose of this property is to give you an opportunity to have a
distinct transaction for the updates to be handled through verses the
operations to select data from the server.
In the case Carlos mentioned, he uses it during cached updates in order to
make it so that the updates are processed through a different isolation than
the data is selected. By using isolation repeatable read your trigger and
stored procedure execution will not be subjected to changes that could be
occurring in other transactions. Thus, it provides an added level of
assurance that things are being modified in exactly the manner desired.
Hope this helps,
Jason LeRoy Wharton
www.ibobjects.com
> I'm noticing a new property called IB_TransForUpdates. Does it meanIf you ignore that new property everything works the same as always.
> that I should be able to assign a read-only TIB_Transaction to the
> IB_Transaction property and assign a read/write TIB_Transaction to the
> IB_TransForUpdates? Or, do I have it wrong? Because when I try to
> set it up that way, I can't edit a record.
The purpose of this property is to give you an opportunity to have a
distinct transaction for the updates to be handled through verses the
operations to select data from the server.
In the case Carlos mentioned, he uses it during cached updates in order to
make it so that the updates are processed through a different isolation than
the data is selected. By using isolation repeatable read your trigger and
stored procedure execution will not be subjected to changes that could be
occurring in other transactions. Thus, it provides an added level of
assurance that things are being modified in exactly the manner desired.
Hope this helps,
Jason LeRoy Wharton
www.ibobjects.com