Moves the current member pointer to the first member in a result set.
TOP [setname]
| setname | The name of a result set. If setname is omitted, the current set is used. |
The TOP command moves the current member pointer to the first record in the current set.
Marks the end of an explicit transaction.
ENDTRANSACTION
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.
Suspends the execution of an application for a specified period of time.
SLEEP seconds
| seconds | A number, or an expression that evaluates to a number, representing the number of seconds to “sleep”. |
When the SLEEP command is encountered in a procedure, execution is suspended for the specified number of seconds. If seconds is negative, zero, or $Null, execution is not suspended.
Marks the end of a group of report commands.
ENDREPORT
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.
Causes execution to be halted and a message to be output.
PAUSE
When the software encounters a PAUSE command, it halts execution (pauses) and displays the message:
Press
Pressing Enter causes execution of the current application program to resume at the command that follows the PAUSE.
The SET PAUSE command governs pauses during output from the LIST and OUTPUT commands. A PAUSE feature is also built into the REPORT FROM command.
The PAUSE message can be altered using the Language Customizer utility.
Ends execution of an application program and returns to the main prompt level.
STOP
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 system.
find all Employees where Salary > 10000
if $setcount = 0
stop
endif
The preceding command returns control to the main prompt level when no set results from the execution of a FIND command.
Marks the end of a transaction in progress, discarding the results.
QUITTRANSACTION
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 an explicit transaction is in progress.
The QUITTRANSACTION command sets the system variable $InTransaction to “0” ($False).
Restarts a WHILE loop.
CONTINUE
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.
while Salary > 20000
… other commands …
if var1 = 1
continue
else
… more commands …
endif
… still more commands …
endwhile…
commands after the while loop …
If var1 is currently set to 1, execution returns to the WHILE command. All commands between CONTINUE and ENDWHILE are ignored, and the “open” IF statement is automatically closed.
Performs a Boolean NOT of a logic expression.
NOT expression
| expression | A logic expression using conditional and Boolean operators. If the expression is complex, it must be enclosed in parentheses. |
Logical.
If expression is logically true, the entire expression, including the NOT, is logically false.
If expression is logically false, the entire expression, including the NOT, is logically true.
not Population > 250000
Uncompiles an application program.
UNCOMPILE progdocname
| progdocname | The name of the application document containing the program to be “uncompiled”. |
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 command has no effect on the disk file that contains the compiled version of the program, but prevents the file from ever being used.
Portuguese 
English