DdfAddIndex
Applies to
VAccess
Description
Adds Indexes to the DDF file and to the corresponding PSQL file. Returns 0 if successful or PSQL status code if an error occurred.
Syntax
object.DdfAddIndex indexList
The DdfAddIndex method syntax has these parts:
 
 
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.
See Also
IndexList, RefreshLocations, DdfTransactionMode, DdfDropIndex