ifselect
CONDITION

The ifselect statement combines the select and if info(“empty”) operations into a single statement.


Parameters

This statement has one parameter:

condition – is a Boolean formula (a formula with a true/false result).


Description

This statement selects a subset of database records using a Boolean formula. If no records match, the statements following the ifselect statement are skipped up until the next else or endif statement.

This example selects all records for John Smith and marks them as Cancelled. However, if there is no one in the database with that name, the message Not found is displayed.

ifselect Customer = "John Smith"
    field Status
    formulafill "Cancelled"
else
    message "Not found"
endif

This statement is a combination of the if, select and info(“empty”) statements.


See Also


History

VersionStatusNotes
10.0NewNew in this version.