Difference between revisions of "COPY TO ARRAY"
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
Line 15: | Line 15: | ||
==Description== | ==Description== | ||
− | The COPY TO ARRAY command allows all or part of the active table to be copied to the | + | The COPY TO ARRAY command allows all or part of the active table to be copied to the specified two-dimensional array, <array>. The target array will be created or resized to accommodate the field list/records from the table. |
− | + | ||
− | + | ||
====FIELDS <field list>==== | ====FIELDS <field list>==== |
Revision as of 12:54, 4 February 2013
Contents
Purpose
Copy current table to an array
Syntax
COPY TO ARRAY <array>
[FIELDS <field list>]
[FOR <condition>]
[WHILE <condition>]
See Also
AAVERAGE(), ACOPY(), ADEL(), ADIR(), AFIELDS(), AFILL(), AINS(), ALEN(), AMAX(), AMIN(), APPEND FROM ARRAY, ASCAN(), ASORT(), ASUM(), AVERAGE, DECLARE, DIMENSION, GATHER, IN_ARRAY(), IS_ARRAY(), LOCAL, PRIVATE, PUBLIC, RELEASE, RESTORE, SAVE, SCATTER
Description
The COPY TO ARRAY command allows all or part of the active table to be copied to the specified two-dimensional array, <array>. The target array will be created or resized to accommodate the field list/records from the table.
FIELDS <field list>
The optional FIELDS clause restricts the operation to those fields listed in <field list>. The <field list> contains a comma-separated list of field names.
FOR <condition>
The optional FOR clause restricts the operation to those records that match the specified <condition>.
WHILE <condition>
The WHILE clause will copy records so long as the <condition> is true (.T.), and is used to restrict the range of records processed. When used in conjunction with the SEEK or LOCATE commands, it allows a quick way of copying selected records. When the WHILE clause is used, the <scope> will default to REST.
Example
declare orders[10000,10] use suppliers copy to array orders for ord_date < date()