image\Dql_0023.gif" " (quotation marks)

Type

Punctuation Symbol

Purpose

Quotation marks are always used to enclose a text constant. Quotes are also used to enclose the name of a variable in a define command, to enclose an custom relationship name when it is first specified in a script by the named operator, and to enclose the name of a Document, Table, or Import specified in a Control Command.

Syntax

"TEXT CONSTANT" define global|temp "VARIABLE NAME" .

sum of MEMBERS named "HIGH VOLUME" with

 TOTAL DUE > 500 ;

run procedure "MEMBERSHIP LIST" .

 

Example

for MEMBERS with STATE = "NY" ;

list records

LAST NAME in order ;

TOTAL DUE ;

STATE .

End

 

This script tells DataEase: For members who live in New York, 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

Baldwin

100.00

NY

Callahan

70.00

NY

Cheng

65.00

NY

Cohen

70.00

NY

Crandall

85.00

NY

Fitzpatrick

100.00

NY

Meier

70.00

NY

Morales

115.00

NY