DdfModifyLocation

Applies to:

Description

Changes the table location of the current table and optionally writes the new location to the DDF.

Syntax

object. DdfModifyLocation newLocation

The DdfModifyLocation method syntax has these parts:

Return Value

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

Remarks

If RefreshLocations is True, the new table location also is updated in the FILE.DDF record of the data dictionary. If False, the change is made only to the VAccess memory image. It could be changed later with DdfAddTable.

This method also causes the value of the Location property of the control to change to reflect the new location.

Because DdfModifyLocation automatically changes the Location property, if DdfKeyUseIndexDDFOnly is set to False, it clears the contents of the current IndexList and replaces it from the index information of the new location (or clears the contents if the file does not yet exist). When you are creating a new file, set the IndexList property after calling DdfModifyLocation rather than before this method is invoked.

See Also

Location, RefreshLocations, DdfAddTable, DdfModifyTableName

Example

	VAEngine.RefreshLocations = True 
	VAEngine.TableName = tableName 
	VAEngine.DdfModifyLocation(newLocation)