>>After making the jump from FoxPro 2.5 to VFP5 I am starting to understand the aspects of buffering and data sessions. In 2.5 I simply used RLOCK() for record locking. If .T. SHOW GETS ENABLED, if false then a message stating that the record is being edited by another user. In VFP my form's DataSession is set to 2-Private and the BufferModeOverride of my cursor in the DE is set to Pessimistic Record Locking. How do I implement the same type of record lock checking in this situation.
>
>My preference is to use Optimistic Buffering. But then your dealing with a different set of problems. Finding out if a change has been made to the data before flushing the change. You will be using TABLEUPDATE(). I would browse the KB. See if they can give you a more precise answer.
>
>HTH

I don't use Optimistic because my users want to know as they choose edit that someone else is editing the record. VFP documentation states that private data sessions are supposed to respect the record locking of the table they represent. However, if one user is editing a record, the ISRLOCKED() function returns .F. on another users machine for that record.