Category: Constructing Statements

The Original Internet Language

How To Use Logic Expressions

A logic expression is an expression that, when evaluated, yields either a $True or a $False result. Logic expressions are subdivided into conditional expressions and Boolean expressions. How To Construct Conditional Expressions A conditional expression is a complex logic expression that consists of two value expressions and an associated conditional operator. The conditional operator performs…
Read more

How To Call Procedures

The syntax of a call to a procedure is procname («expression») Parameters procname The name assigned to the procedure in its PROCEDURE or LOCALPROCEDURE command. expression Any value expression. Comments The list of expressions must be enclosed in parentheses; even when no expressions are required, the parentheses must still appear. At the prompt level, you…
Read more

How To Construct a Validation Rule for Numeric Fields

The available pattern symbols for constructing numeric validation rules are digits used to form specific numbers. Numbers indicate value(s) to which the input data must conform. +, – used to specify the sign of a number. period used as a decimal point. The available syntax characters for constructing numeric validation rules are – Denote a…
Read more

Case Sensitivity

Except in certain limited instances (e.g., security passwords, values held in objects of data type CHAR and VARCHAR), the software is case insensitive. Insensitivity to case means that the software makes no distinction between uppercase and lowercase letters in any part of a statement. For example, the following statements are identical, provided LastName is not…
Read more

How To Use the Null Property

When certain atomic expressions (variable name, field name, form field name, or formal parameter name) are used before being assigned values, or if the values are unknown, those expressions are considered to be $Null. $Null is a property indicating a state of valuelessness; $Null is not itself a value. The null string is a value…
Read more

How To Construct a Validation Rule for Date Fields

The available pattern symbols for constructing date validation rules are digits used to form numbers that constitute valid dates. The input data must conform to the specified date(s). The available syntax characters for constructing date validation rules are – Denote a range of dates. | Separates alternative dates or ranges of dates. Examples of Date…
Read more

How To Take Advantage of Rounding

The results of value expressions are rounded automatically, but only after the entire expression has been evaluated. (During evaluation, full decimal values are used.) The final result takes on the number of decimal places found in the operand with the most decimal places. The rounded result is further rounded if it is being assigned to…
Read more

How To Construct Hex Codes

Within a quoted character string, a backslash immediately followed by two characters that are either digits from 0 to 9 or letters from A(a) to F(f) are treated as a hex code. The text string containing the hex code must be enclosed in quotation marks. Example of Using Hex Codes set output printeroutput “F”;    % selects…
Read more

How To Switch Windows Under Keystroke Control

The Alt+F6 keystroke combination cycles the user through all available windows if the current window is not modal. Its effect is similar to clicking the mouse to make a non-current window current. The Ctrl+F6 keystroke combination cycles through all available sibling windows of a child window.

How To Use Named Constants

A named constant is a programming object defined in the Object Dictionary for the application. The constant’s value is part of its definition. By using named constants in place of literal constants in application programs, you ensure that a constant’s value can be quickly, easily, and universally changed, if necessary.  

en_CAEnglish