Data Transfer from a Table to an Array
The following Visual FoxPro commands transfer data from a table to an array:
SCATTER transfers data from a single table record to an array.
COPY TO ARRAY transfers data from a series of records to an array.
SELECT - SQL can transfer the results of a query to an array. For details about SELECT - SQL, refer to the topic Arrays and SELECT - SQL.
SCATTER and COPY TO ARRAY differ in the following respects:
SCATTER transfers data from the current record in the current table. COPY TO ARRAY can transfer data from multiple records in the current table.
The SCATTER BLANK option automatically creates an array having elements the same size and type as the fields in the table, but the array elements are empty.
The SCATTER VAR option automatically creates a set of variables having the same size, type, and name as the fields in the table.
See Also
Concepts
Data Transfer from an Array to a Table