>I have the following problem. (Buffering is 3 – Optimistic row buffering is on)
>
>Sue enters a new record and locks it. Bill enters a new record and attempts also to RLOCK() but the lock fails.
>
>I suspend Sue's process and browse the table. The record she inserted has moved up by one and she is now sitting on Bill's new record and has it locked.
>
>I can reproduce this. Can anyone help with this?
It'd be interesting to see a reproducing code.
Why do you need an insert followed by a lock ? You say it's row buffered. It wouldn't go on to disk till you leave the record or explicitly tableupdate.
You might be more comfortable with buffering 5.
Cetin