Pervasive.SQL Features Unavailable in the ActiveX Interface

The following features are a part of Pervasive.SQL but are not supported in the ActiveX interface.

SQL Syntax

The ActiveX interface exposes a transactional interface to the Pervasive.SQL database. It does not expose a relational model interface or provide SQL query processing functionality.

Chunk Operations, Huge Records

Pervasive's ActiveX interface does not support Pervasive.SQL chunk operation primitives. The maximum record size supported by the ActiveX interface is dictated by data dictionary limitations. The fixed record length limit is 4 KB, the combined fixed and variable length maximum is 32 KB.

Creating Files with Multiple ACS

The ActiveX interface does not expose interfaces to allow the creation of new tables with multiple Alternate Collating Sequences (ACS). However, the ActiveX interface will collate these indexes correctly in tables that use them.

Data Types

The following Pervasive.SQL data types are not supported by the ActiveX interface:

URI Syntax

Pervasive ActiveX uses the HostAddress and DatabaseName properties to build a URI for connection to remote machines. However, you cannot specify all the URI syntax parameters using code. If a database is secure, the prompt=yes parameter is used by the ActiveX controls to tell the MicroKernel interface to prompt the user for credentials.