About This Manual
Who Should Read This Manual
Typographical Conventions
Introduction to ActiveX
Overview of the ActiveX Access Method
Development Environments
Third-Party Data Bound Controls
ActiveX Control Objects
Choosing the ActiveX Access Method
When should I consider using the ActiveX Access Method?
Key Features of ActiveX Access Method
Data Source for Data-aware Controls in VB
Field-level Access
Property and Method Interface
Extended Operations
DDFs
ActiveX DDF Access Methods
Remote Data Access
Joined Tables
PSQL Features Unavailable in the ActiveX Access Method
SQL Syntax
Chunk Operations, Huge Records
Creating Files with Multiple ACS
Data Types
URI Syntax
First Steps with ActiveX Controls
Creating a Database
Importing ActiveX Access Method into Visual Basic and Delphi
Visual Basic
Delphi
ActiveX Quick Start
Files and Directories Used with ActiveX
Creating an Application with the ActiveX Access Method
Adding the ActiveX Access Method to a Project
Using a VAccess Control
Accessing Properties
Property Pages
Visual Basic Properties Window
Visual Basic Code Editor
Setting Properties
Connecting to a PSQL File
Selecting an Index
Setting Automatic vs. Manual File Opening
Example
Linking Bound Controls to a Data Source
Retrieving Records
Example
Searching for a Specific Record
Example
Adding, Updating, and Deleting Records
Example
Locking Records
Example
Joining Files
Enabling Extended Operations
Using the Init Method
Building a Data “Snapshot” with the AutoMode Property
Using Extended Fetch Methods
Using ExtendedOps with Joined Files
Optimizing Extended Fetches
Distributing and Registering PSQL ActiveX Files
Additional Information on the ActiveX Access Method
Using Data Dictionary Methods with ActiveX
DDF Handling with the ActiveX Data Source Control
File Contents Versus Memory Image
Reading a Dictionary File
Modifying a Dictionary File
Creating a Table Definition
Creating a Dictionary
Modifying a Data File
Other DDF Manipulations
Securing DDFs with an Owner Name
Deleting Existing Field and Index Information
Forcing Comments with Persisted DDF Memory Image
ActiveX Methods with Wide-Ranging Effects
ActiveX Control Reference
VAccess Data Source
Description
Remarks
Custom Properties, Events, and Methods
VACheck
Description
Remarks
Custom Properties and Methods
VACombo
Description
Remarks
Custom Properties and Methods
VACommand
Description
Remarks
Custom Properties
VAHScroll and VAVScroll
Description
Remarks
Custom Properties
VAList
Description
Remarks
Custom Properties and Methods
VAOption
Description
Remarks
Custom Properties and Methods
VAText
Description
Remarks
Custom Properties and Methods
Properties, Methods, and Events By Category
Introduction to ActiveX Properties, Methods, and Events
Retrieving Sets of Records
Properties and Methods
Events
File Handling
Properties and Methods
Data Dictionary Methods
Properties and Methods
Accessing Fields in a Record
Properties and Methods
Inserting, Updating, and Deleting Records
Properties and Methods
Events
Retrieving Individual Records
Properties and Methods
Events
Optimization and Debugging
Properties and Methods
ActiveX Property Reference
AutoDialog
Applies to
Remarks
See Also
AutoLogon
Applies to
Remarks
See Also
AutoMode
Applies to
Description
Remarks
See Also
AutoOpen
Applies to
Description
See Also
Buffer
Applies to
Description
Syntax
Remarks
See Also
CacheRejectMax
Applies to
Description
Remarks
See Also
CacheRows
Applies to
Description
Remarks
See Also
CancelDialog
Applies to
Description
Remarks
See Also
Column
Applies to
Description
Remarks
See Also
ColumnName
Applies to
Description
Remarks
See Also
Columns
Applies to
Description
Remarks
Example
See Also
ColumnWidth
Applies to
Description
See Also
CompressData
Applies to
Remarks
See Also
DatabaseName
Applies to
Remarks
See Also
DataLength
Applies to
Description
Remarks
See Also
DdfKeyUseIndexDDFOnly
Applies to
Remarks
See Also
DdfPath
Applies to
Description
Remarks
Mapped Drives
Uniform Resource Locator
Universal Naming Convention
Example
See Also
DdfTransactionMode
Applies to
Remarks
See Also
ExtendedOps
Applies to
Description
Remarks
See Also
FieldList
Applies to
Remarks
Example
See Also
Fields
Applies to
Description
See Also
FieldValue
Applies to
Description
Syntax
Remarks
Example
See Also
FileVersion
Applies to
Description
Remarks
FireEvents
Applies to
Description
Remarks
FocusSelText
Applies to
Description
HostAddress
Applies to
Remarks
See Also
HostConnect
Applies to
Remarks
See Also
IncludeCurrent
Applies to
Description
Remarks
See Also
IndexList
Applies to
Remarks
Example
See Also
IndexNumber
Applies to
Description
Remarks
See Also
IntegralHeight
Applies to
Description
Remarks
Join
Applies to
Description
Syntax
Remarks
Example
See Also
KeyNumber
Applies to
Description
Remarks
See Also
List
Applies to
Description
Syntax
Remarks
Example
Location
Applies to
Description
Remarks
Example
See Also
Locked
Applies to
Description
Syntax
MaxBufferSize
Applies to
Description
Remarks
See Also
MaxLength
Applies to
Description
Remarks
OemString
Applies to
Description
Remarks
OpenMode
Applies to
Description
Remarks
See Also
OwnerName
Applies to
Description
Remarks
Example
See Also
PageSize
Applies to
Description
Remarks
See Also
Percentage
Applies to
Description
Syntax
Remarks
Example
See Also
Port
Applies to
Remarks
Position
Applies to
Description
Remarks
Example
See Also
RefreshLocations
Applies to
Remarks
Example
See Also
Row
Applies to
Description
Remarks
Example
See Also
RowPosition
Applies to
Description
Remarks
See Also
Rows
Applies to
Description
Remarks
Example
See Also
SelectedFields
Applies to
Description
Remarks
Example
See Also
SelectedRecords
Applies to
Description
Syntax
Remarks
See Also
SessionID
Applies to
Description
Remarks
See Also
Status
Applies to
Description
See Also
TableName
Applies to
Description
Example
See Also
TimeOutVal
Applies to
Remarks
TotalRecords
Applies to
Description
Remarks
Example
See Also
Uppercase
Applies to
Description
Remarks
VAccessName
Applies to
Description
Remarks
VAAutoScroll
Applies to
Description
Remarks
VADataType
Applies to
Description
Remarks
VADebugMode
Applies to
Description
Remarks
VADecimal
Applies to
Description
Remarks
VAErrorDialog
Applies to
Description
Remarks
VAFieldName
Applies to
Description
Remarks
VAFormat
Applies to
Description
Remarks
Example
VALockBias
Applies to
Description
Remarks
VAOffset
Applies to
Description
Remarks
VAOperation
Applies to
Description
Remarks
VARecordList
Applies to
Description
Remarks
VASearch
Applies to
Description
Remarks
VASize
Applies to
Description
VAValueFalse
Applies to
Description
Remarks
VAValueTrue
Applies to
Description
Remarks
ActiveX Method Reference
AboutBox
Applies to
Description
AddItem
Applies to
Description
Syntax
Remarks
Example
Btrv
Applies to
Description
Syntax
Remarks
Example
Clear
Applies to
Description
Syntax
Remarks
Example
Close
Applies to
Description
Syntax
Remarks
Example
DdfAddIndex
Applies to
Description
Syntax
Return Value
Remarks
See Also
DdfAddTable
Applies to
Description
Syntax
Return Value
Remarks
Example
See Also
DdfAddTableName
Applies to
Description
Syntax
Return Value
Remarks
Example
See Also
DdfClearFields
Applies to
Description
Syntax
Return Value
Remarks
See Also
DdfClearIndexes
Applies to
Description
Syntax
Return Value
Remarks
See Also
DdfCreateDictionary
Applies to
Description
Syntax
Return Value
Remarks
See Also
DdfCreateTable
Applies to
Description
Syntax
Return Value
Remarks
Example
See Also
DdfDropIndex
Applies to
Description
Syntax
Return Value
Remarks
Example
See Also
DdfDropIndexMaintain
Applies to
Description
Syntax
Return Value
Remarks
Example
See Also
DdfDropTable
Applies to
Description
Syntax
Return Value
Remarks
See Also
DdfGetFieldComments
Applies to
Description
Syntax
Return Value
Remarks
Example
See Also
DdfModifyLocation
Applies to
Description
Syntax
Return Value
Remarks
Example
See Also
DdfModifyTableName
Applies to
Description
Syntax
Return Value
Remarks
See Also
DdfSetOwner
Applies to
Description
Syntax
Remarks
Example
DdfTestOwnerName
Applies to
Description
Syntax
Return Value
Remarks
See Also
Delete
Applies to
Description
Syntax
Remarks
Example
FormatFieldValue
Applies to
Description
Syntax
Remarks
Example
See Also
GetDirect
Applies to
Description
Syntax
Remarks
GetEqual
Applies to
Description
Syntax
Remarks
Example
GetFirst
Applies to
Description
Syntax
Remarks
Example
GetGreater
Applies to
Description
Syntax
Remarks
Example
GetGreaterOrEqual
Applies to
Description
Syntax
Remarks
Example
GetLast
Applies to
Description
Syntax
Remarks
Example
GetLess
Applies to
Description
Syntax
Remarks
GetLessOrEqual
Applies to
Description
Syntax
Remarks
GetNext
Applies to
Description
Syntax
Remarks
Example
GetNextExtended
Applies to
Description
Syntax
Remarks
Example
GetPrevious
Applies to
Description
Syntax
Remarks
GetPreviousExtended
Applies to
Description
Syntax
Remarks
GetTableList
Applies to
Description
Syntax
Return Value
Remarks
Example
See Also
GetTotalSegments
Applies to
Description
Syntax
Example
Init
Applies to
Description
Syntax
Remarks
Example #1 - Automode = True
Example #2 - Automode = False
Insert
Applies to
Description
Syntax
Remarks
Example
Open
Applies to
Description
Syntax
Remarks
Example
Refresh
Applies to
Description
Example
RemoveItem
Applies to
Description
Syntax
Remarks
RowColumnValue
Applies to
Description
Syntax
Remarks
Example
SetFileFlag
Applies to
Description
Syntax
Remarks
Example
SetOwner
Applies to
Description
Syntax
Remarks
See Also
ShowSelectedFieldsDlg
Applies to
Description
Syntax
Remarks
Example
ShowSelectedRecordsDlg
Applies to
Description
Syntax
Remarks
Example
Stat
Applies to
Description
Syntax
Return Value
Remarks
StatusDialog
Applies to
Description
Syntax
Example
StepFirst
Applies to
Description
Syntax
Remarks
StepLast
Applies to
Description
Syntax
Remarks
StepNext
Applies to
Description
Syntax
Remarks
StepNextExtended
Applies to
Description
Syntax
Remarks
StepPrevious
Applies to
Description
Syntax
Remarks
StepPreviousExtended
Applies to
Description
Syntax
Remarks
Transaction
Applies to
Description
Syntax
Remarks
Unlock
Applies to
Description
Syntax
Remarks
Update
Applies to
Description
Syntax
Remarks
Example
ActiveX Event Reference
CommError
Applies to
Description
Syntax
Remarks
Logon
Applies to
Description
Syntax
Remarks
OnRemote
Applies to
Syntax
Remarks
See Also
Reposition
Applies to
Description
Syntax
Validate
Applies to
Description
Syntax
Remarks
About This Manual
ActiveX Event Reference
activex_propref_chap