IgnoreNulls Property

See Also        Applies To

Sets or returns a value that indicates whether records that have Null values in their index fields have index entries (Microsoft Jet workspaces only).

Syntax

VOIDSetIgnoreNulls(BOOL bFlag);

BOOLGetIgnoreNulls(VOID);

Parameters

Remarks

To speed up the process of searching for records, you can define an index for a field. If you allow Null entries in an indexed field and expect many of the entries to be Null, you can set the IgnoreNulls property for the CdbIndex object to True to reduce the amount of storage space that the index uses.

This property is read/write for a new CdbIndex object not yet appended to a collection and read-only for an existing CdbIndex object in an Indexes collection.

The IgnoreNulls property setting and the Required property setting together determine whether a record with a Null index value has an index entry.