Classic Data Control for Btrieve Enterprise(TM)

The most advanced programming tool for Btrieve and Pervasive SQL.

The Classic Data Control for Btrieve Enterprise is a high performance ActiveX (OCX), data access control for Btrieve, Netware Btrieve and Pervasive SQL. Through a comprehensive set of properties, methods, events and functions it provides complete control and access to all of the features and operations of the Btrieve Microkernal Engine. It will also act as a data source control for any data aware control. This includes Grid, list box, combo box, text, option, etc. It combines the ease of data binding of the standard Visual Basic data control with high performance and flexible access to Btrieve. The standard data binding interfaces are also available under Visual C++ version 4.2 or later.

The Classic Data Control for Btrieve properties and methods interface is modeled after ADO. It has familiar properties and methods like BookMark, RecordCount, AbsolutePosition, MoveFirst, MoveNext, MoveLast, MovePrevious, FindFirst, FindLast, FindNext, FindPrevious, Seek, Filter, MoveRows, etc. The methods and properties have been extended around this base to provide access to all of the features of the Btrieve Microkernal engine. So it also includes support for all Btrieve transactions, record locking, open modes, client ids, etc. Since it makes direct calls into the Btrieve Microkernal it is very fast. Providing 10X or more performance over ODBC. Yet remains very easy to use.

This page contains detailed information on the Classic Data Control for Btrieve Enterprise editions. A subset list of the Properties, methods, events and functions supported by the controls are provided. Also included is a set of screen shots of the tabbed dialog interface provided by the controls for easy configuration.

KEY FEATURES

• Complete interface to Btrieve though a comprehensive set of properties, methods, events and functions. Btrieve database programming has never been easier.
• Provides standard data binding under Visual Basic 4.0, 5.0, 6.0 and Visual C++ 4.2 or later. True codeless data binding to hundreds of data aware controls.
• High performance access with smaller memory and resource requirements. Only one OCX and support DLL under 32 bit. Only one OCX required under 16 bit.
• Easy to use design time interface for configuration of your Btrieve database access.

Advanced features

It provides a DDL interface for creating and editing DDF files. Secondly, the Enterprise Edition frees you of the need for a DDF via several different avenues. This is all controlled by the controls DictionaryBinding property.

• Design time. Referenced dictionary definitions are stored in the controls property stream and are read into memory when the control is loaded.
• User defined. Methods are provided for defining your files “on the fly”. Definitions are stored in local memory for fast access. Data binding is available on defined fields.
• File bound. When “file bound” the control will provide in-memory file, field and index definitions for each of the file’s keys and segments as well as the overall record. Data binding is available for any key or key segment. Even SQL queries and find methods can be performed using these pseudo fields.
• Unbound file. Reading and writing of records is performed as a byte stream. Access to records is done via user defined types. All Btrieve key based searches are supported.

Use it as a Class or Control

The Enterprise Edition also can be used as a Class or Control. It will work with anything that supports CreateObject. So you can use it with ASP, VB Script, any VBA enabled application and more. So you can put it on a Form or other container as a Control or use it in a module, script or anywhere as a Class.

Properties, Methods, Events and Function summary table

The Data Control for Btrieve has a comprehensive set of properties, methods, events and functions providing complete access to the Btrieve Microkernal engine. Below is a subset of these properties.

Core Properties

Core Methods

Core Events

Core Functions

Advanced Properties

Advanced Methods

Advanced Events

Easy to use design time interface

In addition to the standard property browsing the Classic Data Control for Btrieve provides an easy to use set of tabbed dialogs for the most important database access properties. The following example shows how to configure the control using the Extended Table recordset type. This recordset type makes use of Btrieve extended operations for database access.

1) Select your DDF and dictionary binding.

2) Pick your record source, recordset type and open mode. The FilePathName property lets you override the file location field in the DDF.

3) Select the fields you want to cache.

4) Define a filter (if any) over the recordset.

5) Define multi-user access to the data

The Data Control for Btrieve Enterprise is truly the most advanced and easy to use programming tool available for Btrieve database development. You can download our demo versions and give them a try for yourself.

Our products support all Btrieve and Pervasive SQL based applications and tools