Condividi tramite


Data Transfer from a Table to an Array

The following Visual FoxPro commands transfer data from a table to an array:

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