findabove
CONDITION

The findabove statement locates the next previous record (above the current record) in the active database for which the specified condition is true.


Parameters

This statement has one parameter:

condition – is a Boolean formula (a formula which results in a true or a false condition).


Description

This statement scans the active database up from the current record and locates the next visible record above the current record for which the specified condition is true.

This example makes the next visible record above the current record for John Smith the active record. Only records above the current record will be searched, records below will be ignored.

findabove Customer = "John Smith"

See the Find statement for additional examples of how various find statements can be used. FindAbove is very similar to the Find statement, except that it only searches the portion of the database above the current record.

Note: The FindBelow statement is similar to the PreviousMatch statement. however, FindAbove allows you to specify a different search condition formula.


See Also


History

VersionStatusNotes
10.0NewNew in this version.