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

Arrays and SQL - SELECT | COPY TO ARRAY Command | SCATTER Command | SELECT - SQL Command | Data Transfer From an Array to a Table | Data Transfer and Arrays | Data Manipulation