Data types

The query language supports four basic data types (boolean, integer, number and string) that may be read from and saved to data base files (e.g. dBase or CSV data files). In addition there are three specialized data types (list, curve and selection bitmap) that are used in application specific contexts.

TypeValues
Booleantrue or false
IntegerWhole numbers in the range of -231 to +231-1.
NumberDouble precision numbers in the range +/- (2-2-52)·21023. The smallest positive non-zero value represented by a number is 2-1074.
StringThe string type represents arbitrary character data. Constant strings are enclosed in single quotes (e.g. ‘hello’).
ListThe list type represents a sequence of values. Depending on the context the a list may be a comma separated string (e.g. 'a,b,c,d'), or a list function whose arguments are the list elements (e.g list('a','b','c')).
CurveThe curve type represents a series of vertices describing a line. Curves are primarily used in the Matrix Builder application, but literal curves may be specified using the curve function (e.g. curve('0,0,10,5, 20,15')).
Selection bitmapThis specialized and less commonly used type contains the results of a record selection query.