Category: Commands

The Original Internet Language

LOCATE

Locates a particular member of a result set and makes it the current member. Syntax LOCATE [num] [set] [WHERE clause] Parameters num The number of records to be located. Num can be an integer constant (e.g., 15, 200); a variable, form field, menu item, or formal parameter that evaluates to an integer; the word ALL.…
Read more

RETURN

Ends execution of an application program and returns to the “previous” command level. Syntax RETURN [TO procedure] Parameters procedure The name of a procedure. Must be an ancestor (i.e., the “parent”, “grandparent”, “great-grandparent”, etc.) of the current procedure. Comments The RETURN command stops execution of the current procedure. If a TO clause is omitted, execution…
Read more

AND

Performs a Boolean AND of two logic expressions. Syntax expression1 AND expression2 Parameters expression1 A logical expression using conditional and Boolean operators. If the expression is complex, it must be enclosed in parentheses. expression2 A logical expression using conditional and Boolean operators. If the expression is complex, it must be enclosed in parentheses. Return Value…
Read more

DETAIL LINE

Specifies the fields that are selected for a report Syntax DETAIL LINE [colheadings] [GRAPHIC [TEMPLATE name]] reportitem [:format:] [WHERE clause] Parameters colheadings Can be COLUMN HEADING OFF Specifies that column break headings are not to be re-displayed at the top of each report page. LEVEL n [WIDTH n ] LEVEL 0 causes level 0 column…
Read more

HELP

Presents online help information. Syntax HELP [topic] Parameters For files that invoke the winhelp executable topic A character string or a number, or an expression that evaluates to a character string or a number. Identifies a particular help topic in the help file. If topic is a character string, the HELP command accesses the help…
Read more

PROCEDURE

Starts and defines a procedure. Syntax PROCEDURE procname ([IN|OUT|INOUT] parm) [LOCAL (var)] Parameters procname A valid object name. Procname must be the name of the existing application document that contains this procedure and must not conflict with a system keyword. IN, OUT, or INOUT Designates the direction in which the associated parm passes a value:…
Read more

LOCALPROCEDURE

Defines and marks the start of a local procedure within an application program. Syntax LOCALPROCEDURE procname> ([IN|OUT|INOUT] parm)[LOCAL(var)] Parameters procname   A valid object name. The name of the local procedure cannot conflict with a software keyword. When a local procedure name conflicts with a pre-defined object name, the local procedure name takes precedence, provided…
Read more

COLUMN BREAK

Breaks the body of column-oriented reports into summary groups. Syntax COLUMN BREAK level [HEADING reportitem [:format:]] [FOOTING reportitem [:format:]] Parameters level The break level number (an integer greater than or equal to zero). In the hierarchy of breaks, the higher the level number, the more minor the break. (For example, a level 1 break also…
Read more

CASE

Enables conditional execution of commands. Syntax CASE WHEN expression commands1 [OTHERWISE commands2] ENDCASE Parameters expression A logical expression (using conditional or Boolean operators). commands1 Commands that are executed if expression is logically true. commands2 Commands that are executed if expression is logically false. Comments A CASE command must always have a corresponding ENDCASE. Any number…
Read more

FIND

Finds records that match specified conditions, producing a result set. Syntax FIND [ num] [ setspec] [EVALUATE clause] [-> clause] Parameters num The number of records to be found. Num can be an integer constant (15, 200); a variable, form field, or parameter that evaluates to an integer; the word ALL. If num is omitted,…
Read more

en_CAEnglish