Icon KeyFieldCount Property

property KeyFieldCount: Integer

Usage

Use the KeyFieldCount property to limit a search on the active multi-column index to a consecutive sub-set (left to right) of the index columns. For example, if the active index for a table consists of three columns, a partial-key search can be conducted using only the first column in the index by setting KeyFieldCount to 1. If the KeyFieldCount property is 0, the table searches on all columns in the index. The active index for a table is specified via the IndexName or IndexFieldNames property.

Information Searches are only conducted based on consecutive indexed columns beginning with the first column in the index. For example if an index consists of three columns, an application can set the KeyFieldCount property to 1 to search on the first column, 2 to search on the first and second columns, or 3 to search on all columns. By default KeyFieldCount is initially set to include all columns in a search.
Image