VAccess Data Source
Show this topic in Library frames
Description
The VAccess control is the data source control. It provides database communication with the source code of an application and data transfer to the other eight bound controls and to third-party controls.
Remarks
The VAccess control is visible at design time as an icon, but is not visible at run time.
Each VAccess control references one table in a database at a time. The control is connected to a database in one of two ways:
- by setting the DdfPath property of the control to the location of the data dictionary files (FILE.DDF, FIELD.DDF, and INDEX.DDF) which define the database. The VAccess control requires DDF files for its database definition at design time. The record source for the control is specified by setting the TableName property to the name of one of the tables in the data dictionary. The physical operating system path to the database file is specified by the Location property, which defaults to the table location defined in the DDF when TableName is chosen..
- by setting the HostAddress property of the control to the name of a machine and the DatabaseName property to a database name on that machine. Choose the table using the TableName property
The OwnerName property allows you to specify an owner name if one is required for opening the table.
Record navigation properties and methods and field access properties provide record data in code. The data source can also be bound to the other controls provided or to third-party data controls that operate as bound controls in Visual Basic.
Custom Properties, Events, and Methods
Custom properties, events, and methods for this control are listed in the following tables in alphabetical order. For lists of custom properties, methods, and events by category, see Chapter , "Properties, Methods, and Events By Category."
The lists of properties does not include stock properties such as (About), (Custom), (Name), Index, Left, Tag, and Top.
Table 4-1 VAccess Custom Properties
|
AutoDialog
|
DataLength
|
IndexNumber
|
RowPosition
|
|
AutoLogon
|
DdfKeyUseIndexDDFOnly
|
Join
|
Rows
|
|
AutoMode
|
DdfPath
|
Location
|
Selected Fields
|
|
AutoOpen
|
DdfTransactionMode
|
MaxBufferSize
|
SelectedRecords
|
|
Buffer
|
ExtendedOps
|
OemString
|
SessionID
|
|
CacheRejectMax
|
FieldList
|
OpenMode
|
Status
|
|
CacheRows
|
Fields
|
OwnerName
|
TableName
|
|
CancelDialog
|
FieldValue
|
PageSize
|
TimeOutVal
|
|
Column
|
FileVersion
|
Percentage
|
TotalRecords
|
|
ColumnName
|
FireEvents
|
Port
|
VADebugMode
|
|
Columns
|
HostAddress
|
Position
|
|
|
CompressData
|
HostConnect
|
RefreshLocations
|
|
|
DatabaseName
|
IncludeCurrent
|
Row
|
|
Table 4-2 VAccess Custom Methods
|
AboutBox
|
DdfGetFieldComments
|
GetLessOrEqual
|
ShowSelectedFieldsDlg
|
|
Btrv
|
DdfModifyLocation
|
GetNext
|
ShowSelectedRecordsDlg
|
|
Clear
|
DdfModifyTableName
|
GetNextExtended
|
Stat
|
|
Close
|
DdfSetOwner
|
GetPrevious
|
StatusDialog
|
|
Create
|
DdfTestOwnerName
|
GetPreviousExtended
|
StepFirst
|
|
DdfAddIndex
|
Delete
|
GetTableList
|
StepLast
|
|
DdfAddTable
|
FormatFieldValue
|
GetTotalSegments
|
StepNext
|
|
DdfAddTableName
|
GetDirect
|
Init
|
StepNextExtended
|
|
DdfClearFields
|
GetEqual
|
Insert
|
StepPrevious
|
|
DdfClearIndexes
|
GetFileFlag
|
OpCode
|
StepPreviousExtended
|
|
DdfCreateDictionary
|
GetFirst
|
Open
|
Transaction
|
|
DdfCreateTable
|
GetGreater
|
Refresh
|
Unlock
|
|
DdfDropIndex
|
GetGreaterOrEqual
|
RowColumnValue
|
Update
|
|
DdfDropIndexMaintain
|
GetLast
|
SetFileFlag
|
|
|
DdfDropTable
|
GetLess
|
SetOwner
|
|
Table 4-3 VAccess Custom Events
|
CommError
|
Logon
|
Reposition
|
|
GotData
|
OnRemote
|
Validate
|
