dataarrayselectedbuild(
DATABASE
,
FORMULA
,
QUERY
)

The dataarrayselectedbuild( function builds a data array by scanning a database and creating an array element for every visible record in the database (see Data Arrays).


Parameters

This function has three parameters:

database – is the database that will be scanned. This database must be currently open. If this parameter is "" then the current database will be scanned. Note: The dataarrayselectedbuild( function will scan every visible record in the database. If you want to build an array that includes both visible (selected) and invisible records, use the dataarraybuild( function.

formula – is the formula that will be used to extract data from the database and build each array element. The entire formula must be enclosed in quotes (see Quotes). The formula usually references fields in the database being scanned. If may also use the seq() function to include the number of each record (within the scan).

query – is an optional formula that determines whether a record should be included in the output array (however, if a record is invisible, it won’t be included even if it matches the query formula). For example, the query formula Price > 100 could be used if you only wanted to include items with a price greater than 100 in the array. The query parameter can be omitted, in which case all records will be included.


Description

This function creates a Data Array by scanning contents of a database. This function scans visible records in the database. If you want to scan both visible (selected) and invisible records, use the dataarraybuild( function.

For details about the operation of this function, see the dataarraybuild( function. These two function are identical except for the fact that dataarraybuild( scans all records and dataarrayselectedbuild( scans only visible (selected) records.


See Also


History

VersionStatusNotes
10.0NewNew in this version.