Finds a record in a table based on the values stored in the key fields.
[Ok :=] RecordRef.FIND([Which]) |
Parameters
- RecordRef
-
Type: RecordRef
The recordref that refers to the table in which you want to find a record.
- Which
-
Type: Text or code
Specifies how to perform the search. The table will be searched until the record is found or there are no more records. Each character in the string can be present only once. You can use the following characters:
-
= search for a record that equals the key values (default)
-
> search for a record that is larger than the key values
-
< search for a record that is less than the key values
-
+ search for the last record in the table (+ can only be used alone)
-
- search for the first record in the table (- can only be used alone)
You can combine the '=', '<', and '>' characters.
If this parameter contains '=', '>', or '<', then you must assign value to all fields of the current and primary keys before you call FIND.
-
