Taken from MSDN VFP5.0a Online Developer's Guide, Part 5, Chapter 15 - "Programming for Shared Access". Also found on pg. 424 of VFP3.0's Developer's Guide.

Commands that Automatically Lock Records and Tables

Command - Scope of lock
------------------------------------------------

ALTER TABLE - Entire table

APPEND - Table header

APPEND BLANK - Table header

APPEND FROM - Table header

APPEND FROM ARRAY - Table header

APPEND MEMO - Current record

BLANK - Current record

BROWSE, CHANGE and EDIT - Current record and all records from aliased
fields in related tables once editing of a field begins

CURSORSETPROP( ) - Depends on parameters

DELETE - Current record

DELETE NEXT 1 - Current record

DELETE RECORD n - Record n

DELETE of more than one record - Entire table

DELETE - SQL - Current record

GATHER - Current record

INSERT - Entire table

INSERT - SQL - Table header

MODIFY MEMO - Current record when editing begins

READ - Current record and all records from aliased fields

RECALL - Current record

RECALL NEXT 1 - Current record

RECALL RECORD n - Record n

RECALL of more than one record - Entire table

REPLACE - Current record and all records from aliased fields

REPLACE NEXT 1 - Current record and all records from aliased fields

REPLACE RECORD n - Record n and all records from aliased fields

REPLACE of more than one record - Entire table and all files from aliased
fields

SHOW GETS - Current record and all records referenced by aliased fields

TABLEUPDATE( ) - Depends on buffering

UPDATE - Entire table

UPDATE - SQL - Entire table