Data Dictionary Methods

Data Dictionary Methods

This section lists the properties and methods which you can use for data dictionary methods.

Properties and Methods

Table 25

Properties and Methods for Data Dictionary Handling

Property or Method

Adds Indexes to the DDF file and to the corresponding PSQL file.

Adds the current table to the current data dictionary.

DdfAddTableName

Adds a new table to the current VAccess control memory image.

Clears the field information in the VAccess memory image for the current table.

DdfClearIndexes

Clears the index information in the VAccess memory image for the current table.

DdfCreateDictionary

Creates a new, empty set of DDF files in the current location.

Adds a table definition to the dictionary and creates an empty data file.

Removes an index from the current PSQL data file and from the data dictionary definition for the current table.

DdfDropIndexMaintain

Removes an index from the current PSQL data file and from the data dictionary definition for the current table while maintaining the ordering of the existing indexes.

Drops the current table from the data dictionary.

DdfGetFieldComments

Reads field comments into the VAccess memory image from the COMMENT.DDF file.

DdfKeyUseIndexDDFOnly

Specifies whether or not the VAccess should use the true indexes of the file or the indexes as specified in the DDF.

DdfModifyLocation

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

DdfModifyTableName

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

Sets the drive and path on which the DDF files associated with this control reside.

Sets the Btrieve owner name for the dictionary files to something other than the default owner name (..SC….) and security level (allow read-only access).

DdfTestOwnerName

Sets the owner name used for opening dictionary files and determines whether or not a dictionary can be successfully opened and updated using the given owner name.

DdfTransactionMode

Determines whether or not updates to the data dictionary tables will take place within a transaction. Accepts or returns a boolean value.

Sets or returns a variant array containing information on the fields of the current table.

Returns the list of tables defined in the current dictionary as a two-dimensional variant array.

Sets or returns a variant array containing information on the indexes of the current table.

Sets or returns the drive, path, and file name of the PSQL file associated with this control.

RefreshLocations

Determines whether the VAccess control will use DDF files for metadata or whether it will use internal states and/or persisted properties for metadata.

Indicates which table, from the set of all tables defined in the current DDF set, will be associated with the control.