Category: Commands

Moves the current member pointer to the first member in a result set. Syntax TOP [setname] Parameters setname The name of a result set. If setname is omitted, the current set is used. Comments The TOP command moves the current member pointer to the first record in the current set.   See Also $currentmember BOTTOM…
Read more

Marks the end of an explicit transaction. Syntax ENDTRANSACTION Comments The ENDTRANSACTION command marks the end of an explicit transaction in progress and commits the changes made during the transaction. Portions of the database that were not available to other users become available. The ENDTRANSACTION command sets $ InTransaction to $False.   See Also BEGIN…
Read more

Suspends the execution of an application for a specified period of time. Syntax SLEEP seconds Parameters seconds A number, or an expression that evaluates to a number, representing the number of seconds to “sleep”. Comments When the SLEEP command is encountered in a procedure, execution is suspended for the specified number of seconds. If seconds…
Read more

Marks the end of a group of report commands. Syntax ENDREPORT Comments The ENDREPORT command is used only in conjunction with a REPORT FROM command. It marks the end of a report. When an ENDREPORT is encountered, the current group of report commands is processed. The resulting report is directed to the current output device.…
Read more

Causes execution to be halted and a message to be output. Syntax PAUSE Comments When the software encounters a PAUSE command, it halts execution (pauses) and displays the message: Press to continue. Pressing Enter causes execution of the current application program to resume at the command that follows the PAUSE. The SET PAUSE command governs…
Read more

Ends execution of an application program and returns to the main prompt level. Syntax STOP Comments The STOP command stops execution of the current application program and returns control to the main prompt level (i.e., outside any application program). STOP is equivalent to BYE when used in a fully compiled application running under the Runtime…
Read more

Marks the end of a transaction in progress, discarding the results. Syntax QUITTRANSACTION Comments The QUITTRANSACTION command ends the explicit transaction in progress and discards any changes or updates made to the database since the TRANSACTION command was issued. The QUITTRANSACTION command is ignored in single-user environments. In multi-user systems, QUITTRANSACTION takes effect only if…
Read more

Restarts a WHILE loop. Syntax CONTINUE Comments Any IF or CASE statements that are still open when a CONTINUE command is executed are automatically closed off when execution returns to the start of the WHILE loop. Example while Salary > 20000   … other commands … if var1 = 1 continue else   … more commands…
Read more

Performs a Boolean NOT of a logic expression. Syntax NOT expression Parameters expression A logic expression using conditional and Boolean operators. If the expression is complex, it must be enclosed in parentheses. Return Value Logical. Comments If expression is logically true, the entire expression, including the NOT, is logically false. If expression is logically false,…
Read more

Uncompiles an application program. Syntax UNCOMPILE progdocname Parameters progdocname The name of the application document containing the program to be “uncompiled”. Comments The UNCOMPILE command marks the specified application program as “not compiled”. If progdocname had not been compiled (using the COMPILE command) when the UNCOMPILE was issued, the software raises a warning. The UNCOMPILE…
Read more