SCATTER
Contents
Purpose
Copy the contents of fields to an array or to a series of memory variables
Syntax
SCATTER [FIELDS <field list> | FIELDS LIKE <skeleton> | FIELDS EXCEPT <skeleton>]
[MEMO]
TO <array> [BLANK] | MEMVAR [BLANK] | [OLDVALUES] NAME <object> [BLANK]
See Also
ADEL(), ADIR(), AFIELDS(), AFILL(), AINS(), ALEN(), APPEND FROM ARRAY, ARRAY(), ASCAN(), ASORT(), COPY TO ARRAY, CURVAL(), DIFFOBJ(), GATHER, IN_ARRAY(), IS_ARRAY(), LOCAL, OLDVAL(), PRIVATE, PUBLIC
Description
The SCATTER command copies the contents of fields from the current table record into an array or series of memory variables.
FIELDS <field list> | FIELDS LIKE <skeleton> | FIELDS EXCEPT <skeleton>
The optional FIELDS clause is used to copy only the contents of fields specified in the <field list> or those matching the LIKE <skeleton> or those not matching the EXCEPT <skeleton>. If the FIELDS clause is not specified, the SCATTER command copies the contents of all fields.
MEMO
By default, memo fields are ignored by the SCATTER command. If the MEMO keyword is specified, memo fields will be included.
To <array> [BLANK]
The fields are copied into consecutive elements of the specified array. If the array does not exist, then it is created. If the BLANK keyword is specified, the elements are created but are empty and are the same size and data types as the specified fields.
MEMVAR [BLANK]
The fields are copied into a series of memory variables with the same name as the field names. If the memory variables do not exist, then they are created. If the BLANK keyword is specified, the memory variables are created but are empty and are the same size and data types as the specified fields.
[OLDVALUES] NAME <object> [BLANK]
The fields are copied as properties of the specified object. If the object does not exist, it is created, otherwise it is overwritten. The use of SCATTER OLDVALUES NAME in combination with SCATTER NAME allows a comparison to be made between a record's previous values and the current buffered values from an uncommitted change. It can also be used for audit trail purposes.
NOTE: 'TO' should not be included in the MEMVAR or NAME clauses.
Example
use addresses index add_1 seek "Seymour House" if found() scatter field like add* to aTemp endif