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
DOWN
LOCATE
NEXT
PREVIOUS
UP
In a template program, indicates that the next line is to be joined to the current line at the output destination.
Syntax
linestart «$
linecontinue »
where
| linestart | any portion, from the beginning, of an output line |
| linecontinue | the remaining portion(s) of the same output line |
Comments
In a template program, the dollar sign ($) indicates that the next line is to be joined to the current line at the output destination.
Normally, each physical line in a template is sent as a separate line to the current output destination. To cause successive physical lines in a template to be joined into one line in the output, end the appropriate lines in the template with the dollar sign ($).
If a line must end with a dollar sign for some other reason, ask the software to interpret the dollar sign by placing a backslash ( – Escape) preceding the dollar sign.
The number of records processed by the most recent set-processing command.
Syntax
$membercount
Return Value
A number. Can be reset by an application program.
Description
The number of records processed by the most recent set-processing command.
See Also
ADD
CHANGE
COMPUTE
DELETE
FIND
INSERT
LIST
REPORT FROM
SELECT
SORT
UPDATE
System Variables
Displays the Printer Setup common dialog box.
Syntax
$printersetup()
Return Value
Evaluates to “1” ($True) if no errors were detected in the dialog. Otherwise, evaluates to “0” ($False).
Comments
This function is available only on Windows systems. The Printer Setup common dialog box contains a list of printers mounted to your Windows network. To access printers not listed in the dialog box, see your system administrator.
See Also
$setproperty
PRINT
Sets the format of the application document.
Syntax
SET DOCUMENT FORMAT UTF-8|ANSI|DBCHARSET
Parameters
| UTF-8 | Selects the UTF-8 character set and writes a UTF-8 BOM at the beginning of the file. |
| ANSI | Selects the ANSII character set. |
| DBCHARSET | Selects the character set used by the current database. |
Comments
Identifies the character set used by application documents.
See Also
$DBCharSet
The number of records found by the last FIND command.
Syntax
$setcount
Return Value
A number. Can be reset by an application program.
Description
The number of records in the result set produced by the most recent FIND command.
Example
find Students where GradePt = 4.00
Produces a set of Students whose GradePt is 4.00. If the set contains three students whose grade point average is 4.00, then $SetCount would be set to 3.
See Also
$lastmember
$MemberCount
System Variables
Marks the end of a transaction, discarding the results.
Syntax
ROLLBACK WORK
Comments
The ROLLBACK WORK command is the SQL equivalent of the QUITTRANSACTION command. The value of the system variable $InTransaction indicates if an explicit transaction is in progress; the ROLLBACK WORK command sets $InTransaction to 0 ($False).
See Also
$InTransaction
BEGIN WORK
COMMIT WORK
ENDTRANSACTION
QUITTRANSACTION
SET TRANSACTION FLOW
TRANSACTION
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 WORK
COMMIT WORK
QUITTRANSACTION
ROLLBACK WORK
SET TRANSACTION FLOW
TRANSACTION
Activates or deactivates the use of the message window for system messages.
Syntax
SET MESSAGES WINDOW ON|OFF
Comments
The MESSAGES WINDOW option is set OFF by default.
When MESSAGES WINDOW is OFF, system messages are displayed line-by-line in the application window (BACKSCREEN). By setting MESSAGES WINDOW ON, you enable a pop-up window for the display of all system messages that are not currently suppressed.
See Also
SET ERRORS
SET INFORMATION
SET MESSAGES
SET OUTPUT
SET WARNINGS
Makes a specified result set the current set.
Syntax
SET CURRENTSET setname
Parameters
| setname | The name of an existing result set. |
Comments
Normally, the current set is the result set produced as a result of the last FIND command executed. SET CURRENTSET enables you to select another existing result set to use as the current set.
The SET CURRENTSET command takes effect immediately upon parsing or compilation, not just when the compiled program is executed.
The SET CURRENTSET command is not affected by the SET RESET and SET RESTORE commands.
Example
procedure test3 (a,b)
if a = b
find Employees -> EmpSet
else
find Departments -> DeptSet
endif
if a = b
set currentset EmpSet
let a = LastName
endif
The SET CURRENTSET command ensures that the correct set is recognized as the current set.