Hi,

>>
3) The table under the "Unlocking Data" section lists "SET MULTILOCKS OFF" and describes its effect as "Enables automatic release of the current lock as a new lock is secured" and the Command Reference for SET MULTILOCKS states "Switching SET MULTILOCKS from ON to OFF or from OFF to ON implicitly issues UNLOCK ALL — all record locks in all work areas are released.". I see a contradiction between the two entries. In fact I can't really understand what the first quotation is actually telling me.
<<

Don't think there's any contradiction here.

The first bit is simply stating that with MULTILOCKS set OFF locking a new record will implicitly release any existing lock on another record.

The second bit says that when you change the state of MULTILOCKS any existing locks are released. This sounds logical to me. If you change MULTILOCKS from ON to OFF then it's logical that an implicit UNLOCK ALL should occur - VFP can't guess which individual record you may want to keep locked. Of course, changing MULTILOCKS from OFF to ON *could* maintain an existing lock if there was one but such behaviour might arguably be seen as less consistent.

Regards,
Viv