ActiveX Controls Guide - Table of Contents

Pervasive PSQL SDK v10 (show all books in this release)

About This Manual

Who Should Read This Manual

Manual Organization

Conventions

Introduction to ActiveX

Overview of the ActiveX Interface

Development Environments

Third-Party Data Bound Controls

ActiveX Control Objects

Choosing the ActiveX Interface

When should I consider using the ActiveX Interface?

Key Features

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

Pervasive PSQL Features Unavailable in the ActiveX Interface

SQL Syntax

Chunk Operations, Huge Records

Creating Files with Multiple ACS

Data Types

URI Syntax

First Steps with ActiveX Controls

Creating a Database with Pervasive Control Center

Importing ActiveX Interface into Visual Basic and Delphi

ActiveX Quick Start

Files and Directories

Creating an Application with the ActiveX Interface

Adding the ActiveX Interface to a Project

Using a VAccess Control

Accessing Properties

Setting Properties

Connecting to a Pervasive PSQL File

Selecting an Index

Setting Automatic vs. Manual File Opening

Linking Bound Controls to a Data Source

Retrieving Records

Searching for a Specific Record

Adding, Updating, and Deleting Records

Locking Records

Joining Files

Enabling Extended Operations

Distributing and Registering Pervasive PSQL ActiveX Files

Additional Information on the ActiveX Interface

Using Data Dictionary Methods with ActiveX

DDF Handling with the ActiveX Data Source Control

File Contents vs. Memory Image

Reading a Dictionary

Modifying the DDF

Creating a Table Definition

Creating a Dictionary

Modifying the Data File

Other DDF Manipulations

Securing DDFs with an Owner Name

Deleting Existing Field and Index Information

Forcing Comments with Persisted DDF Memory Image

Methods with Wide-Ranging Effects

ActiveX Control Reference

VAccess Data Source

VACheck

VACombo

VACommand

VAHScroll and VAVScroll

VAList

VAOption

VAText

Properties, Methods, and Events By Category

Introduction

Retrieving Sets of Records (Extended Operations)

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

AutoLogon

AutoMode

AutoOpen

Buffer

CacheRejectMax

CacheRows

CancelDialog

Column

ColumnName

Columns

ColumnWidth

CompressData

DatabaseName

DataLength

DdfKeyUseIndexDDFOnly

DdfPath

DdfTransactionMode

ExtendedOps

FieldList

Fields

FieldValue

FileVersion

FireEvents

FocusSelText

HostAddress

HostConnect

IncludeCurrent

IndexList

IndexNumber

IntegralHeight

Join

KeyNumber

List

Location

Locked

MaxBufferSize

MaxLength

OemString

OpenMode

OwnerName

PageSize

Percentage

Port

Position

RefreshLocations

Row

RowPosition

Rows

SelectedFields

SelectedRecords

SessionID

Status

TableName

TimeOutVal

TotalRecords

Uppercase

VAccessName

VAAutoScroll

VADataType

VADebugMode

VADecimal

VAErrorDialog

VAFieldName

VAFormat

VALockBias

VAOffset

VAOperation

VARecordList

VASearch

VASize

VAValueFalse

VAValueTrue

ActiveX Method Reference

AboutBox

AddItem

Btrv

Clear

Close

DdfAddIndex

DdfAddTable

DdfAddTableName

DdfClearFields

DdfClearIndexes

DdfCreateDictionary

DdfCreateTable

DdfDropIndex

DdfDropIndexMaintain

DdfDropTable

DdfGetFieldComments

DdfModifyLocation

DdfModifyTableName

DdfSetOwner

DdfTestOwnerName

Delete

FormatFieldValue

GetDirect

GetEqual

GetFirst

GetGreater

GetGreaterOrEqual

GetLast

GetLess

GetLessOrEqual

GetNext

GetNextExtended

GetPrevious

GetPreviousExtended

GetTableList

GetTotalSegments

Init

Insert

Open

Refresh

RemoveItem

RowColumnValue

SetFileFlag

SetOwner

ShowSelectedFieldsDlg

ShowSelectedRecordsDlg

Stat

StatusDialog

StepFirst

StepLast

StepNext

StepNextExtended

StepPrevious

StepPreviousExtended

Transaction

Unlock

Update

ActiveX Event Reference

CommError

Logon

OnRemote

Reposition

Validate


Pervasive logo
Pervasive Software, Inc.
http://www.pervasive.com
Voice: (512) 231-6000
Fax: (512) 231-6597
Pervasive Sales Support
Contact Technical Support
Pervasive DevTalk Forums
Pervasive Developer Center
Show book location in tree-view of Pervasive Library Index