Share via


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

Concepts

Data Transfer from an Array to a Table

Reference

Arrays and SELECT - SQL

COPY TO ARRAY Command

SCATTER Command

SELECT - SQL Command

Other Resources

Data Transfer and Arrays

Data Manipulation