This document contains the following topics:
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.
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
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
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. |
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.
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.