View source for COPY TO ARRAY

From Recital Documentation Wiki

← COPY TO ARRAY

You do not have permission to edit this page, for the following reason:

---

You can view and copy the source of this page:

==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== <code lang="recital"> declare orders[10000,10] use suppliers copy to array orders for ord_date < date() </code> ==Products== Recital Database Server, Recital Mirage Server, Recital Terminal Developer [[Category:Documentation]] [[Category:Commands]]

Return to COPY TO ARRAY.