SQR Command Overview
The commands in this section follow the conventions listed in the section SQR Syntax Conventions in the previous topics, and they use the abbreviations described in the following table.
Warning! If you are copying code directly from the examples in the PDF file, make sure that you change the slanted quotes to regular quotes or you will receive an error message.
Abbreviation |
Description |
Example |
---|---|---|
txt_col |
Text column retrievable from a database. |
&address |
num_col |
Numeric column retrievable from a database. |
&price |
date_col |
Date or datetime column retrievable from a database. |
&date1 |
txt_var |
String variable defined in a program. |
$your_name |
num_var |
Numeric variable defined in a program. |
#total_cost |
date_var |
Variable explicitly defined as a date variable. |
$date1 |
any_lit |
A literal of any type. |
'abc' 12 |
any_var |
A variable of any type. |
$string #number $date |
any_col |
A column of any type. |
&string &number &date |
txt_lit |
Text literal defined in a program. |
'Company Confidential' |
num_lit |
Numeric literal defined in a program. |
12345.67 |
int_lit |
Integer literal defined in a program. |
12345 |
nn |
Integer literal used as an argument to a command. |
123 |
position |
The position qualifier, which consists of the line, column, and length specification. The minimum position, (), means you use the current line and column position on the page for the length of the field being printed. |
(5,10,30) |