Overview of the ActiveX Interface

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.

This section features the following subsections:

Development Environments

The ActiveX interface supports the following environments:

Third-Party Data Bound Controls

Pervasive's ActiveX interface can bind data from Sheridan, APEX, GreenTree, and Microsoft Controls. Pervasive Software only recommends using these third-party products when they have formatting or presentation functionality not present in Pervasive's ActiveX interface.

Because Pervasive Software cannot control the development of third-party software, it does not support all of the functionality of these controls. For the same reason, it cannot offer technical support on these products.

---

Note
Data binding to third-party data-aware controls is not supported in any environment other than Microsoft Visual Basic.

---

ActiveX Control Objects

The ActiveX control objects included with the ActiveX interface are listed in the following table:

Table 1-1 Included ActiveX Control Objects 

Icon	Control	Description
	VAccess	The data source control provides your application source code and Pervasive PSQL Bound Controls access to a data file.
	VACheckBox	Check box can be bound to boolean (True/False) type fields.
	VAComboBox	Data-bound combo box can be bound to one field in a record, allowing the user to select a value for the field from a predetermined set of values. It can also serve as a record list control, or as a list of available index fields.
	VACommandButton	Data-bound command button can execute record retrieval, update, or delete operations.
	VAHScrollBar VAVScrollBar	Data-bound scroll bars allow the user to scan through records along an index path.
	VAListBox	The list box control allows the user to select a field value from a predetermined set of values. It can also serve as a multi-column record list control.
	VAOptionButton	The option button may be bound to a boolean (True/False) type field.
	VATextBox	The data-aware text box can automatically display and permit modification of any field. It also can be used in search mode to seek matching records from a file as text is entered.