The binarydatabuild( function builds a binary value by scanning a database and assembling individual binary values for every record (including unselected records) in the database.


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 binarydatabuild( function will scan every record in the database, including records that are not currently selected. If you want to build an array from only selected records, use the query parameter.

formula – is the formula that will be used to extract data from the database and build the binary value for each record. This formula should generate binary data, not text or numbers. 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 value. 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.


This function creates a binary value by scanning contents of a database. This function is similar to dataarraybuild(, but instead of generating a data array, it generates a single binary value. You would normally only use this function if you needed to generate a special binary data value for an external program.

See Also


10.2NewNew in this version.