Specifies a database expression (also known as an SQL expression) that cannot include 4GL reference or array variables, 4GL procedures, or the 4GL field function

Specifies the simple variable that receives the value from a specified dbexpression. The data types of the receiving object and dbexpression must be compatible.

See BeginEndBlock (see BeginEndBlock).

Identifies the column name (for example, for subsequent fetch statements) in which a dbexpression is placed

Specifies the name of the table containing the columns from which data is to be selected. This is a dynamic name.

Specifies the correlation name that you give to a table. If this parameter is omitted, the table name is used as the correlation name.

Specifies a logical database expression of conditions that must be satisfied by all rows selected. You can use simple variables (preceded by colons) in a search condition wherever you can use a literal. Alternatively, you can place the entire search condition in a single varchar variable, and specify the search condition as the name of this variable (preceded by a colon).

Specifies the name of a column in the database table from which data is selected and by which rows are grouped. This name is a dynamic name.

Specifies a column or list of columns on which to sort. For more information, see Order By Clause (see Order By Clause).

Specifies the entire from clause as a single varchar variable, preceded by a colon. This is a dynamic name.

Specifies the entire group by clause as a single varchar variable, preceded by a colon. This is a dynamic name.

Specifies the entire order by clause as a single varchar variable, preceded by a colon. This is a dynamic name.