IndexNumber

Applies to:

Description

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

Remarks

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 Pervasive.SQL operation being performed. See the Pervasive.SQL 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 Pervasive.SQL, 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 Pervasive.SQL 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.

See Also

Affects: Join

Affected by: TableName