Key Features

Pervasive's ActiveX interface includes a number of to make developing applications with Pervasive.SQL.

Data Source for Data-aware Controls in VB

Pervasive's ActiveX interface can be used as a data source by other data-aware controls in Visual Basic, including third-party controls such as Apex TrueGrid grid controls or Sheridan Data Widgets. The Pervasive Bound Controls in Visual Basic and in other development environments.

Field-level Access

The ActiveX interface uses data dictionary files (DDFs) to provide field-level access to Pervasive.SQL data. Fields can be referenced either by name or by ordinal. All Pervasive.SQL field data types except LVAR are supported.

Property and Method Interface

In addition to the control objects, the ActiveX interface provides a number of properties and methods for programming convenience and flexibility. These properties and methods enable you to set up and execute a number of Pervasive.SQL operations without extensive coding and to manipulate the data in code through interaction with the Pervasive.SQL bound controls, the programming environment, or other third-party controls.

Extended Operations

Pervasive's ActiveX interface simplifies using Pervasive.SQL extended operations, which provide client/server record set caching, field selection, and record filtering capabilities.

Extended operations provide the means to minimize network traffic when running distributed applications against centralized databases, improve performance, and simplify the implementation of multi-row objects such as grid controls and record lists.

DDFs

The ActiveX interface, like the ODBC interface, requires DDFs. Use the Pervasive Control Center to DDF files and databases.

For more information about the Pervasive Control Center, see the Pervasive.SQL User's Guide or the Control Center online help.

ActiveX DDF Access Methods

The data source includes methods for accessing DDF information from within your application code.

Remote Data Access

In addition to workstation and client/server options, the ActiveX interface can provide access to Pervasive.SQL data using URIs.

Joined Tables

The Join property of the VAccess control allows you to specify that two files are to be linked by a key value, so that any changes in the record positioning of the first file will also affect the records retrieved from the second. The Join property provides a simple mechanism for browsing a relational database.