Subject | TIB_Cursor Commits |
---|---|
Author | Bill Gage |
Post date | 2005-02-16T16:35:41Z |
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
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