This property corresponds to the maximum reject count parameter in the PSQL extended get operation structure (see the Get Next Extended documentation in the PSQL Programmer's Guide).

Specifying a value for the CacheRejectMax property limits the number of records which PSQL can skip while searching for records which meet the SelectedRecords property filter conditions. A zero value in this property will use a system-defined maximum. You can use this property to optimize read times for a given query. The valid range for this property is 0 (default) through 65,535 records. If no value is specified for the SelectedRecords property, setting this property has no effect.

This property may be used by GetNextExtended, GetPreviousExtended, StepNextExtended, or StepPreviousExtended methods, or by a VAccess control running in AutoMode, responding to a request for a specific Row value.

If PSQL reaches the CacheRejectMax value while processing an extended fetch, the fetch operation will return the set of records encountered in processing the fetch operation which meet the record selection criteria and a status value of 64, indicating that filter limit for rejected records was reached.

The ExtendedOps property must be set to True to enable the extended operations capabilities of the VAccess control.

Affects: GetPreviousExtended, GetNextExtended, StepPreviousExtended, StepNextExtended

Affected by: SelectedRecords, ExtendedOps