Pervasive PSQL v9 ActiveX Controls - May 2006

This document contains the following topics:


About the ActiveX Controls

Pervasive's ActiveX interface is a set of nine custom controls that enable development environments that support ActiveX to easily access Btrieve data. The interface includes a data source control and eight bound data controls.

The Pervasive PSQL data source control provides the connection point between your application and a Btrieve data file. In addition to acting as a data source for other data-aware controls, the data control also exposes properties, methods, and events you can use to access data from code in your application-opening, closing, and creating files; and retrieving, updating and deleting records.

The Pervasive PSQL bound controls, which must be attached to the data source control, include data-aware text box, list box, combo box, check box and option button controls. The list and combo box controls operate either as field-bound controls or as multi-column record list controls.

Command button and horizontal and vertical scroll bar controls provide indexed record navigation.

In Microsoft Visual Basic, the Pervasive PSQL data source control can also act as a record source for data-aware Visual Basic controls, and for third-party data-aware ActiveX controls.

System Requirements

Getting Started

Installer

Install the ActiveX controls by running setup.exe. You can choose Typical, Complete, or Custom installations. The Typical installation omits the MSI redistributable files found in the Complete installation. For more information about ActiveX, see the ActiveX section of the Pervasive Developer Center at http://www.pervasive.com/developerzone/access_methods/activex.asp

Components List

The installation will then proceed to install the following ActiveX components to the \pvsw\bin directory for a Typical or Complete Install:

Component

Description

ACBTR732.OCX

ActiveX Data Access Control

ACCTR732.OCX

ActiveX Bound Controls

PBTRVD32.DLL

Meta data handling DLL

PEDTCONV.DLL

Data conversion DLL

Files relating to Redistributing ActiveX in other installations are installed with a Complete install or Custom install if selected. If installed, they are located in \sdk\Redist\ActiveX\msi

Known Issues in this Release

The following are known issues with this release.

Issue Number Description
52378 After connecting to and disconnecting from a remote host, VAccess properties still displays table name and selected fields of the previously connected database.
52379 DdfPath, Location, and Join buttons cannot be operated from the keyboard.
53342 The ActiveX controls do not update LONGVARCHAR type fields. They read existing data, but if you change the field and do an update/insert, status returns success, but the field has not changed. I This is not a new issue with 9.5 (all 9.x versions have it) but it would be great if it could be resolved.
53378 ActiveX does not support the entire range of BigInt values. This is also an issue in previous Pervasive PSQL versions.
53784 ActiveX does not support the GUID/UNIQUEIDENTIFIER data type.
53785 ActiveX does not support the DateTime data type.

Useful Links

Discuss all your Pervasive development issues at DevTalk at http://www.pervasive.com/devtalk.

See some creative applications and code snippets and share your own at Pervasive ComponentZone at http://www.pervasive.com/componentzone.

Disclaimer

PERVASIVE SOFTWARE INC. LICENSES THE SOFTWARE AND DOCUMENTATION PRODUCT TO YOU OR YOUR COMPANY SOLELY ON AN "AS IS" BASIS AND SOLELY IN ACCORDANCE WITH THE TERMS AND CONDITIONS OF THE ACCOMPANYING LICENSE AGREEMENT.
PERVASIVE SOFTWARE INC. MAKES NO OTHER WARRANTIES WHATSOEVER, EITHER EXPRESS OR IMPLIED, REGARDING THE SOFTWARE OR THE CONTENT OF THE DOCUMENTATION; PERVASIVE SOFTWARE INC. HEREBY EXPRESSLY STATES AND YOU OR YOUR COMPANY ACKNOWLEDGES THAT PERVASIVE SOFTWARE INC. DOES NOT MAKE ANY WARRANTIES, INCLUDING, FOR EXAMPLE, WITH RESPECT TO MERCHANTABILITY, TITLE, OR FITNESS FOR ANY PARTICULAR PURPOSE OR ARISING FROM COURSE OF DEALING OR USAGE OF TRADE, AMONG OTHERS.

Copyright (c) 1999-2006 Pervasive Software Inc. All Rights Reserved.