Difference between revisions of "COPY TO ARRAY"
Yvonne.milne (Talk | contribs) m (1 revision) |
|||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Copy current table to an array | Copy current table to an array | ||
| − | |||
==Syntax== | ==Syntax== | ||
| Line 11: | Line 10: | ||
[WHILE <condition>] | [WHILE <condition>] | ||
| − | |||
==See Also== | ==See Also== | ||
| − | [[AAVERAGE | + | [[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== | ==Description== | ||
| Line 30: | Line 27: | ||
====WHILE <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. | 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== | ==Example== | ||
| Line 39: | Line 35: | ||
</code> | </code> | ||
| − | |||
| − | |||
| − | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
Revision as of 08:54, 16 November 2011
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 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()
