>Thank you Ed. It’ll help me. And one questions more. If I use commands: LOCATE, UPDATE, REPLACE do fox before copies data to local station. Thank you.
It depends on the scope of the operation and what mechanisms VFP has to attempt to optimize data access. LOCATE, for example, if no mechanism for performing a search is available to optimize access (index tags usable for Rushmore optimization) then the only mechanism available is to examine the table record by record until a record is found that satisfies the FOR expression.
UPDATE/REPLACE are clearly scoped to the FOR; REPLACE by default afects only the current record. If you say REPLACE ALL then it has to manipulate each record.
Read the section on optimizing table access in VFP for documentation.