Difference between revisions of "COPY TO ARRAY"
Helengeorge (Talk | contribs) (→Class) |
Helengeorge (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Copy current table to an array | Copy current table to an array | ||
| Line 43: | Line 41: | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital Server, Recital |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
[[Category:Table Basics]] | [[Category:Table Basics]] | ||
[[Category:Table Basics Commands]] | [[Category:Table Basics Commands]] | ||
Revision as of 15:32, 10 November 2009
Contents
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 Server, Recital
