Subject Re: [firebird-support] Re: Locking tables
Author Aage Johansen
nagypapi wrote:
> ...
>>
>>Other apps that try to update recurrents cannot get a lock on the row
>>and thus drop back to normal operations.
>
>
> Do you do a commit after updating the 1 row?
> If so, what happens if a client crashes just after commiting that 1 row?


Don't commit just after the update. A commit (or rollback) will release
"the lock".
After a crash: "the lock" will be rolled back.


--
Aage J.