forExpression

Topic group

Limits the records included in the index to those meeting a specific condition.

Property of

DbfIndex

Description

Use the forExpression property to specify which rows in a set to include in the index by entering a condition that restricts the operation to certain rows. For example, entering, COMPANY = "Santa Cruz Dry Goods", restricts the index to rows for which the COMPANY field evaluates to the string "Santa Cruz Dry Goods".