Difference between revisions of "COPY TO ARRAY"

Latest revision as of 08:05, 10 February 2017

Purpose

Copy current table to an array

Syntax

COPY TO ARRAY <array>

[<scope>]

[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.

<scope>

If no <scope> is specified, then the default is ALL.

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()