The CacheRows property determines the maximum number of rows to return in any single Pervasive PSQL extended fetch operation.
The highest possible setting for this property will depend upon the byte length of the returned rows, which in turn is dependent upon the value of the SelectedFields property if there is one, or the defined data buffer length of the data file if there is not. This property corresponds to the “number of records to be retrieved” parameter in the fixed portion of the data extractor in the extended get operation structure (see the Get Next Extended documentation in the
Pervasive PSQL Programmer's Guide).
The ExtendedOps property must be set to
True to enable the extended operations capabilities of the VAccess control.
Affected by: ExtendedOps, MaxBufferSize, SelectedFields, Init