COPY TO ARRAY

From Recital Documentation Wiki
Revision as of 13:12, 18 March 2009 by Yvonnemilne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

COPY TO ARRAY

Class

Fields and Records


Purpose

Copy current table to an array


Syntax

COPY TO ARRAY <array>

[FIELDS <field list>]

[FOR <condition>]

[WHILE <condition>]


See Also

AAVERAGE(), ACHOICE(), ACOPY(), ADEL(), ADIR(), AFIELDS(), AFILL(), AINS(), ALEN(), AMAX(), AMIN(), APPEND FROM ARRAY, ASCAN(), ASORT(), ASUM(), AVERAGE(), DECLARE, DIMENSION, GATHER, 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()


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer