Icon FindNearest Method

function FindNearest(const KeyValues: array of const): Boolean

Usage

Call the FindNearest method search for a row 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 column 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 row that exactly matches the search criteria, returning True, or on the first row whose values are greater than those specified in the search criteria, returning False.
Image