IndexNumber

Sets or Returns the current index number for the PSQL table associated with the VAccess control.

Use this property to determine which index to use when retrieving records from the data file.

The valid range of index values for a data file is 0 through the value of the TotalKeys property minus one.

This property may have other meanings, depending upon the PSQL operation being performed. See the PSQL Programmer's Guide documentation for the values for specific operations.

If you want to perform a no-currency-change operation, use the KeyNumber property.

In PSQL, indices are maintained with the data file, and these are numbered sequentially, zero representing the first index. You may use any index defined in the PSQL file by specifying the index number of that index in this property. The value of this property is undefined for a data-only file.

Because Joins are dependent on the current index, changing IndexNumber will blank out any Joins that are in place.

Affected by: TableName