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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only