directly to the data of the DataWindow object in the control. This direct data manipulation allows you to access small and large amounts of data in a single statement, without calling functions.
There are several variations of data expression syntax, divided into three groups. This section summarizes the syntax for the three groups. The syntaxes are described in detail later in this chapter.
Data in columns or computed fields when you know the name
One or all items in the column (if rownum is absent, include either buffer or datasource)
Returns a single value (for a specific row number) or an array of values (when rownum is omitted).
See "One or all items in a named column or computed field".
Selected items
Returns an array of structures or user objects. The structure elements match the columns in the range. There is one array element for each row in the range.
Returns one structure or user object (for a single row) or an array of them (for all rows). The structure elements match the columns in the DataWindow object.
Returns an array of structures or user objects. The structure elements match the columns in the DataWindow object. There is one array element for each selected row.
See "Selected rows".
Summary of syntaxes
This diagram summarizes the variations in data expression syntax:
For information about getting and setting values of DataWindow object properties using a similar syntax, see "Basic syntax" and "Syntax for nested objects".