DdfAddIndex

Applies to:

VAccess

Description

Adds Indexes to the DDF file and to the corresponding Pervasive.SQL file. Returns 0 if successful or Pervasive.SQL status code if an error occurred.

Syntax

object.DdfAddIndex indexList

The DdfAddIndex method syntax has these parts:


Part	Description
object	Required. The name of a valid VAccess control.
indexList	Required. A two-dimensional array of index information as described in the reference for IndexList.

Return Value

DdfAddIndex returns a two-byte integer that holds the status of the VAccess control. If this is zero, the operation completed successfully.

Remarks

DdfAddIndex will add the index(es) in indexList to the actual data file itself. In addition, this function will add the index(es) in indexList to the metadata memory image of the VAccess control. If RefreshLocations is True, DdfAddIndex will then update the DDF files themselves to match the current memory image. If DdfTransactionMode is True, these actions will be performed inside a transaction.

Note
DdfAddIndex alters the index structure of the data file itself. Use with caution.