>Stephen
>
>With pessimistic locking you can also execute a "replace myval with myval" to lock the record.
>FP handles pessimistic locking better than most systems, especially those that use page locking and can paralyse many records if one record is locked. But IMHO there are usually good reasons to use Optimistic locking. The notorious "lunch lock" is one reason (pessimistic-lock user locks record and walks away, leaving record inaccessible) and optimistic locking does allow ways to manage contention.
>
>Regards
>
>JR

Completely agree. I'd rather use optimistic locking anyday but this particular client is specifying pessimistic.....if someone has it, lock everyone else out, period. So what the heck........I did what they want, they write the check.

Steve