Click above to get retro games delivered to your door ever month!

Syntax: N_SCATTER([<namesA> ,] <dataA>)

Scatters (stores) database fields to specified array.

Example

* move all fields from client record to array
SELECT Client
DECLARE data[FCOUNT()]
N_SCATTER(data)

* move selected fields from client record to data array
SELECT Client
DECLARE fields[3],data[3]
fields[1] = "Name"
fields[2] = "City"
fields[3] = "Phone"
N_SCATTER(fields,data)

Notes

If only one array is specified then all fields from the DBF record are moved
to the array.  The number of elements moved is the smaller of the size of
the array or the number of fields in the DBF record.  If the array size is
longer than the number of fields, then the trailing array elements are
unchanged.

If two elements are specified then the first array is assumed to contain a
list of field names to be moved to the corresponding element of the second
array.  The second array must be at least the same size as the first array
or the results will be undefined.

N_SCATTER does not move memo fields.