Subject | Re: TIB_Cursor Commits |
---|---|
Author | Rick Roen |
Post date | 2005-02-16T17:52:18Z |
My uneducated guess is that this has something to do with your
transaction - be it explicit or the default transaction that is
created by the TIB_Connection.
Check your "Isolation" setting and change to tiCommitted and see if
this helps. I think the latest version of IBO just changed from a
default of something else to tiCommitted because of the problems it
caused.
Also, read about the Isolation settings in the IBO help - this is an
important topic to understand.
Rick
transaction - be it explicit or the default transaction that is
created by the TIB_Connection.
Check your "Isolation" setting and change to tiCommitted and see if
this helps. I think the latest version of IBO just changed from a
default of something else to tiCommitted because of the problems it
caused.
Also, read about the Isolation settings in the IBO help - this is an
important topic to understand.
Rick
--- In IBObjects@yahoogroups.com, "Bill Gage" <wcgage@y...> wrote:
>
> Is there some special rules to follow when using the TIB_Cursor
when
> editing the current record and posting the changes.
>
> This is what I am running into.
>
> I open my SQL query using a TIB_Cursor.
>
> before I edit the record I start a transaction,
> set the cursor into Edit mode,
> make my changes
> Post the changes
> commit the transaction
>
> while still using the current record, I try doing the above again
> and I get the following error
>
> deadlock
> update conflicts with concurrent update
>
> How can I prevent this from happening?
>
> Bill