Icon FindNearest Method

procedure FindNearest(const KeyValues: array of const)


Call the FindNearest method search for a record in the table that is greater than or equal to the values specified in the KeyValues parameter using the active index. The IndexName or IndexFieldNames property specifies the active index. The KeyValues parameter contains a comma-delimited array of field values. If the number of values passed in the KeyValues parameter is less than the number of columns in the active index, the missing values are assumed to be null. FindNearest positions the table either on a record that exactly matches the search criteria, or on the first record whose values are greater than those specified in the search criteria.