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