Transferring Data from a Table to an Array

See Also

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 section, Arrays and SELECT - SQL, later in this chapter.

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.