Icon FindKey Method

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


Call the FindKey method to search for a specific record in a table using the active index. The IndexName or IndexFieldNames property specifies the active index. The KeyValues parameter contains a comma-delimited array of field values. Each value in the KeyValues parameter can be a literal, a variable, a null, or nil. If the number of values passed in the KeyValues parameters is less than the number of columns in the active index, the missing values are assumed to be null. If a search is successful, the FindKey method positions the table on the matching record and returns True. Otherwise the current table position is not altered, and FindKey returns False.