TMedTable.FindNearest TMedTable

procedure FindNearest(const KeyValues: array of const);

Description

Use FindKey to find a record in a dataset. KeyValues contains a comma-delimited array of field values used as a search key. Key values can be literals, variables or Nil's. If the number of passed values is less than the number of column indexed with active index, it is assumed the last values are Nil's.

Key values must correspond to fields of the current index as set with IndexName. This index is used to perform a search.

If successful, FindKey positions the cursor on the matching record or the first record with key values grater then specified. If no such record exist, cursor is positioned on the last record.

See TTable.FindNearest for more details.