image\Dql_0023.gif; (semicolon)

Type

Punctuation Symbol

Purpose

A semicolon is used to separate items in a script action. The semicolon is always used after a for command that specifies the script's Primary table; after ad hoc selection criteria are specified; and after each output item except the last in a list records, modify records, or enter a record command.

The semicolon is used after a for command that specifies a script's Primary table; it is not used with a nested for command that specifies a table other than the Primary table.

Syntax

FIELDNAME|CONSTANT VALUE ;

Example

for MEMBERS with TOTAL DUE > 180 ;

list records

LAST NAME in order ;

TOTAL DUE ;

STATE .

end

 

This script tells DataEase: For members whose TOTAL DUE is greater than $180, list each member's LAST NAME, TOTAL DUE, and STATE. The report output, arranged in alphabetical order by LAST NAME, might look as follows:

 

Last Name

Total Due

State

Christino

280.00

VA

Perrault

215.00

CT

Stafford

185.00

AZ

Strachan

205.00

OR