Overview of PSQL Direct Access Components

Overview of PSQL Direct Access Components

The PSQL Direct Access Components (PDAC) is a set of Visual Component Library (VCL) components that allow direct access to PSQL database engines from within the Embarcadero Delphi and C++ Builder Environments. These components offer a complete replacement for the Borland Database Engine (BDE), while providing the complete functionality of the BDE. PDAC dramatically extends the database development options available to Delphi and C++ Builder developers.

Refer to the PDAC readme file for the development environments supported by the PSQL Direct Access Components.

All versions of PDAC contain the following nonvisual components:

•

•

•

•

•

•

•

•

Supporting classes are also provided for these components.

These 32-bit components duplicate the properties, methods, and binding capabilities of the Embarcadero Data Access components, but without requiring the presence of the Borland Database Engine (BDE) at run time.

These components are provided in package format, and offer all the design time and runtime functionality of the built-in controls. They bind to the Embarcadero Data Aware controls in the same way as the BDE components, as well as to fully compatible third-party bound controls.

Special components include wwPvTable, wwPvQuery, and wwPvStoredProc and are provided for interoperability with the Woll2Woll InfoPower components.

Engine Version Checking

When opening a query or table, PDAC checks for an adequate PSQL engine version to ensure that engine dependency-related errors do not occur. If the engine version is not sufficient, an exception is thrown with a message indicating the required version.

TPvQuery.PassThrough

Allows SQL text to be sent directly to the engine instead of being preparsed.

TPvDatabase.OEMConversion

This property indicates that the database contains characters encoded according to the OEM (DOS) code page, and that these characters should be converted to the ANSI (Windows) code page before use.

Where to Get More Information

Please see SDK Downloads for sample code and code snippets for the PSQL Direct Access Components. You can find the online location for SDK Downloads for PDAC at the Actian PSQL website.