Subject Re: Concurrency problem when using named cursors
Author hvlad
--- In firebird-support@yahoogroups.com, "roger" wrote:
>
> If, in PSQL, I open a named cursor on a record, and some other operation changes a field in that record, then the change is lost when I post using the cursor, even if the cursor does not fetch the changed field.
>
> If I define the cursor as FOR UPDATE OF MY_FIELD WITH LOCK, then the system crashes if, after some other operation changes the record, I try to post using the cursor.
>
> How do I maintain concurrency when using named cursors? Am I doing something wrong?

Enter it into tracker, please.

Regards,
Vlad