Difference between revisions of "COPY TO ARRAY"

Revision as of 10:54, 4 February 2013

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 previously declared two-dimensional specified array, <array>. The target array must have elements defined that match the field list from the table.

NOTE: If SET COMPATIBLE is set to FOXPRO | FOXPLUS | FOXBASE the array need not be pre-defined, it will be created automatically.

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