Visual Programmer's Reference - Table of Contents

Pervasive.SQL 8.7 (code VIS_870, revision 1)  Sync manual in Pervasive Library

About This Manual

Where to Get Information

Who Should Read This Manual

Manual Organization

ADO/OLE DB Reference

Pervasive Direct for Delphi and C++ Builder

ActiveX Reference

Distributed Tuning Objects Reference

Conventions

ADO/OLE DB Reference

ADO/OLE DB Reference Information

Setting up Visual Basic for Pervasive.SQL OLE DB Programming

Non-Visual Programming

Visual Programming

Creating a Connection

Creating a Recordset Using a Named Database

Creating a Recordset Using a Path

Creating a Recordset Using the Location Parameter

Creating a Recordset Using an Existing Connection

Navigating Through and Manipulating Data

Adding Records

Deleting Records

Updating Records

Searching for Records

Selecting Deferred-Update or Immediate-Update

Immediate-update mode

Deferred-Update Modes

Using ADO Objects

Using Bookmarks

Using Events

Using the Field Object

Using Transactions

Where to Get More Information on ADO and OLE DB

Programming Concepts

OLE DB Reference Information

Pervasive.SQL OLE DB Provider Implementation

Pervasive.SQL OLE DB Provider Implementation Reference

Command

Connection

Field

Fields

Parameter

Record

Recordset

Stream

ADOX Implementation Reference

Catalog

Columns

Column

Group

Index

Indexes

Connection

Procedure

Tables

Table

Visual Studio.NET Implementation Reference

Pervasive Direct Access Components

Using Direct Access Components

Overview of Pervasive Direct Access Components for Delphi and C++ Builder

New in Pervasive.SQL V8 (v8.5)

New in Pervasive.SQL V8 (v8.0)

New in Pervasive.SQL 2000i

Using the Pervasive Direct Access Components

Differences Between Pervasive and Borland Implementation

TransIsolation Property Differences

DSN-Less Connections

Deploying an Application Based on PDAC

Deciding whether to Use Runtime Packages

Redist Subdirectory

IDS Deployment

Deployment Instructions for PDAC

PDAC Security

Owner Name Security

SQL Security

Adding IDEs after Installing the SDK

Where to Get More Information

Direct Access Components Reference

PDAC Classes, Properties, Events, and Methods

Exception Classes

Supporting classes

General Differences from VCL

Specific Class Differences from VCL

Pervasive.SQL and Borland Data Types

Pervasive.SQL and Borland

Btrieve and Borland

ActiveX Reference

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

I*net Data Server Access

Properties and Methods

Events

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

Distributed Tuning Objects Reference

Distributed Tuning Objects Introduction

What is DTO?

Objects Model and Objects Relationship

Connection

Monitoring and Diagnostic

Configuration

Catalog and Dictionary

DTO Object Tree

DTO2

Getting Started with DTO

Visual Basic

Active Server Pages

Delphi

Object Summary

Connection Object

Configuration Objects

Monitoring Objects

Database and Dictionary Objects

Working with Collections

Instantiating a Collection

Looping through a Collection

Obtaining Number of Members

Obtaining a Specific Member

Where to Find DTO Samples

Establishing a DTO Session

DtoSession Object

Methods Detail

Configuring Pervasive Servers with DTO

DtoCategories Collection

DtoCategory Object

DtoLicenseMgr Object

DtoSettings Collection

DtoSetting Object

DtoSelectionItems Collection

DtoSelectionItem Object

DtoServices Object

Monitoring Pervasive Servers with DTO

DtoMonitor Object

DtoOpenFiles Collection

DtoOpenFile Object

DtoFileHandles Collection

DtoFileHandle Object

DtoMkdeClients Collection

DtoMkdeClient Object

DtoMkdeClientHandles Collection

DtoMkdeClientHandle Object

DtoCommStat Object

DtoProtocolStats Collection

DtoProtocolStat Object

DtoSqlClients Collection

DtoSqlClient Object

DtoMkdeVersion Object

DtoEngineInformation Object

Creating and Maintaining Catalogs and Dictionaries with DTO

DtoDatabases Collection

DtoDatabase Object

DtoDSNs Collection

DtoDSN Object

DtoDictionary Object

DtoTables Collection

DtoTable Object

DtoColumns Collection

DtoColumn Object

DtoIndexes Collection

DtoIndex Object

DtoSegments Collection

DtoSegment Object

Distributed Tuning Objects Enumerations

Enumerated Types in DTO

Btrieve Types

Column Flags

Index Flags

Segment Flags

Table Flags

DtoResult

Setting Rank

Setting Type

Client Site

Client Platform

Transaction State

Open Mode

DSN Open Mode

Lock Type

Wait State

Database Flags

SQL Connection Status

Service ID

Service Status