Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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