GetTableList

Applies to:

VAccess

Description

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

Syntax

object. GetTableList


Part	Description
object	Required. The name of a valid VAccess control.

Return Value

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

Remarks

The FieldList property accepts and returns a variant encapsulating a two-dimensional variant array. The first subscript references the field ordinal, and the second references one property of the field. The properties referenced by the second subscript are:


Subscript	Name	Variant Type	Description
0	tableID	VT_I2	Unique key for the file table dictionary entry.
1	tableName	VT_BSTR	The name of the table, 20 characters max storage limit.
2	tableLocation	VT_BSTR	The operating system or network path and file name of the data file referenced by the table, 64 characters max storage limit.

If the RefreshLocations property is False, the last table list cached in memory is returned. If RefreshLocations is True, the current table list will be re-read from the dictionary. This method only allows read operations and not updates as opposed to FieldList and IndexList.

Example

VAEngine.RefreshLocation = True 
	VAEngine.DDFPath = path 
	tables = VAEngine.GetTableList