Difference between revisions of "APPEND FROM ARRAY"

From Recital Documentation Wiki
Jump to: navigation, search
Line 1: Line 1:
=APPEND FROM ARRAY=
 
 
 
 
==Class==
 
==Class==
 
Fields and Records
 
Fields and Records
Line 21: Line 18:
  
 
==See Also==
 
==See Also==
[[AAVERAGE()]], [[ACHOICE()]], [[ACOPY()]], [[ADEL()]], [[ADIR()]], [[AFIELDS()]], [[AFILL()]], [[AINS()]], [[ALEN()]], [[AMAX()]], [[AMIN()]], [[APPEND FROM]], [[ASCAN()]], [[ASORT()]], [[ASUM()]], [[AVERAGE()]], [[COPY TO ARRAY]], [[DECLARE]], [[DIMENSION]], [[GATHER]], [[INDEX]], [[PRIVATE]], [[PUBLIC]], [[REINDEX]], [[RELEASE]], [[RESTORE]], [[SAVE]], [[SCATTER]]
+
[[AAVERAGE()]], [[ACHOICE()]], [[ACOPY()]], [[ADEL()]], [[ADIR()]], [[AFIELDS()]], [[AFILL()]], [[AINS()]], [[ALEN()]], [[AMAX()]], [[AMIN()]], [[APPEND FROM]], [[ASCAN()]], [[ASORT()]], [[ASUM()]], [[AVERAGE]], [[COPY TO ARRAY]], [[DECLARE]], [[DIMENSION]], [[GATHER]], [[INDEX]], [[PRIVATE]], [[PUBLIC]], [[REINDEX]], [[RELEASE]], [[RESTORE]], [[SAVE]], [[SCATTER]]
  
  

Revision as of 12:35, 24 March 2009

Class

Fields and Records


Purpose

Append records to current table from an array


Syntax

APPEND FROM ARRAY <array>

[FOR <condition>]

[WHILE <condition>]

[REINDEX]


See Also

AAVERAGE(), ACHOICE(), ACOPY(), ADEL(), ADIR(), AFIELDS(), AFILL(), AINS(), ALEN(), AMAX(), AMIN(), APPEND FROM, ASCAN(), ASORT(), ASUM(), AVERAGE, COPY TO ARRAY, DECLARE, DIMENSION, GATHER, INDEX, PRIVATE, PUBLIC, REINDEX, RELEASE, RESTORE, SAVE, SCATTER


Description

The APPEND FROM ARRAY command allows you to append records to the current table from the contents of a previously declared two-dimensional array of the specified name, <array>. The data types and sizes of elements in the rows of the arrays must correspond to the fields in the table.

FOR <condition>

If the FOR <condition> clause is specified, only those elements in the rows which satisfy the specified <condition> will be appended.

WHILE <condition>

The WHILE <condition> clause can be used to restrict the number of records appended. When the condition becomes false, the APPEND FROM ARRAY operation will stop.

REINDEX

The REINDEX keyword can be used to automatically call the REINDEX command after the APPEND FROM ARRAY has completed.


Example

use suppliers
declare cust[reccount(), fcount()]
copy to array cust
copy structure to customer
use customer
append from array cust for also_cust = .T.


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer