Classic Data Control For Btrieve ™

Professional and Enterprise (OLE Automation) Editions

Btrvpro1
The most advanced tool for Btrieve database development

Data Control Pro Icon Image

The Classic Data Control for Btrieve Professional is a high performance ActiveX (OCX), data access control for Btrieve. It has all of the features of the Classic Data Control for Btrieve Standard Edition but adds several more powerful features. First, it provides a DDL interface for creating and editing DDF files. Secondly, the Professional Edition frees you of the need for a DDF via several different avenues. This is all controlled by the controls DictionaryBinding property.

Key Features

[Bullet] Shares the same set of properties and methods of the Classic Data Control for Btrieve Standard Edition.So you get the same easy access to Btrieve. Code is backward compatible to standard edition.
[Bullet] Includes new properties and methods for file and index creation and a DDL interface for data dictionary (DDF) creation and editing. Creates DDF files in either Pervasive 2000, 7.x or 6.x (or earlier) format.
[Bullet] Frees your from the need for data dictionary (DDF) files.
[Bullet] Just like the standard edition the professional edition will binds to any data aware ActiveX (OCX) control under .NET, Visual Basic 4.0, 5.0, 6.0 and Visual C++ 4.2 or later. Get true codeless binding to any data aware control on the market. Bind to data aware grids, combo boxes, list boxes, edit controls, option buttons, etc. Its like getting hundreds of controls in one box. With the Professional edition you can perform data binding even if you do not have a DDF!
[Bullet] A true Btrieve tool. This product has been customized and optimized for Pervasive SQL and Btrieve database development.
[Bullet] Works with any programming tool that support ActiveX controls. This includes, but is not limited to, .NET, Visual Basic, Access, Delphi, Visual Foxpro, Visual C++ and many more.
 
Click here for more detailed information on the Classic Data Control for Btrieve properties, methods, events, functions and design time interface.
 

Enterprise (OLE Automation) Edition

The Enterprise Edition supports any VBA enabled application, VB Script and Active Server Pages (ASP). The Enterprise edition adds the ability to treat the control as just another class. No need for a form or container to host the control. Simply declare a variable of the class type or use the standard CreateObject function. This allows you to use the control in a non visual way and still use all of its methods and properties to read and write to your Btrieve data. Of course you can also use it as a visual control on a form or dialog just like the Professional edition.

' Create using Create Object. You can also place as control onto form.
 
dim x as Object
dim v as variant
 
x = CreateObject("BTRVOLEPRO.BtrvOlePro")
x.DatabaseName = "g:\mydata\file.ddf"
x.RecordSource = "Customer"
x.OpenMode = 5 ' Open normal mode
 
ret = x.Open ' Open the file
 
ret = x.MoveFirst
do while ret = 0
v = x.Field("LastName")
ret = x.MoveNext
loop
 
Find customer with last name of Smith.
ret = x.FindFirst("Lastname = Smith")
 
Or search on an index on last name.
x.Seek "=", "Smith"
if x.NoMatch = False then
' Found record.
End If

Built in data export capabilities to a number of data interchange formats.

The Professional and Enterprise Editions support the export of Btrieve and Pervasive SQL data to a number of interchange formats. You can export data to the clipboard, text files, sequential files and even other Btrieve files. You get incredible amounts of control through just a few properties and methods. Export plain text or unicode. Format with tab delimited, comma delimited, csv or other custom delimited formats. You can also export to Fixed size formats for FTP and mainframe data transfers. Sort ascending or descending on any index or physical position. Export only the fields that you want and in any order th at you want. Filter the records you want to export via a SQL syntax. Append or overwrite any pre existing exported data. Delete the records after successful export, and more. And all controlled via setting just a few properties. You will not believe how easy it is. You simply configure the data you want and call the ExportData method. The Control makes direct calls into the Btrieve Microkernal. And since the Control will use Btrieve Extended operations it will extract the fastest and most efficient way that can possible be done via Btrieve. This 10x and more faster than any ODBC driver. And easier to use as well.

Just one simple example to show just how easy it is: Continuing from example above.

 
x.CachedFields = "FirstName, LastName, CompanyName, address1, address2, zipcode"
x.Filter = "LastPurchaseDate > 10-22-2000"
 
ret = x.Requery ' Execute filter and field selection.
 
x.InterchangeTarget = 1 ' Text File
x.InterchangeTextType = 0 ' Plain text
x.InterchangeTextFormat = 2 ' csv format
x.InterchangeHeaders = True ' Output field names on first line
x.InterchangeRange = 0 ' Entire recordset.
x.InterchangeFilePath = "g:\expdata\btrv.txt" 'File Name to export to
x.InterchangeTraversal = 0 ' From low to high along key path
x.InterchangeOperation = 0 ' Overwrite the file if it already exists
 
ret = Btrv.ExportData(0) ' Export the data to the text file.
 
Want to export the same data to the clibboard?
 
x.Interchangetarget = 0 ' Export target is clipboard
ret = Btrv.ExportData(0) ' Export the data to the clipboard.
 
Now simply paste the data into notepad, excel spreadsheet, etc.

And the great thing is you can execute this from just about any programming tool, and target environment. And with our 32 Bit Power Pack for Btrieve you can even run it against legacy Netware Btrieve and 16 bit Btrieve databases.

Our tools provide support for all versions of Pervasive SQL, Btrieve, and Netware Btrieve (32 or 16 bit). Supported software products include Crystal Reports, Macola, Great Plains, Dynamic, Platinum, Peachtree, Maximizer and many others. Programming tools supported include Visual Basic, Visual C++, Access, Visual Foxpro, Visual J++, ODBC and OLE DB drivers, VBA enabled applications, VBScript, ASP and many other tools and utilities.

[HRule Image]

Pricing

DESCRIPTION			PRICE    
Standard Edition		$149.95  
Professional Edition		$249.95  
Enterprise Edition		$349.95

Order the Classic Data Control for Btrieve.

[HRule Image]

Copyright © 1996, 1997, 1998, 1999, 2000, 2001, 2002 by Classic Software, Inc. All rights reserved.
All specifications subject to change without notice.
Data Manager for Pervasive SQL and Btrieve, Developers Toolkit for Pervasive SQL and Btrieve, 32 Bit Power Pack for Btrieve, Classic Data Control for Btrieve, Btrv++, Btrvgen++, DDF Maker, and VBtrv Toolbox Controls for Btrieve are trademarks of Classic Software, Inc.
Btrieve and Pervasive SQL are a registered trademark of Pervasive Software.
Other products and companies referred to herein are trademarks or registered trademarks of their respective companies or mark holders.
Send mail to sales@classicsoftware.com with questions or comments about this web site.
For technical support send mail to support@classicsoftware.com
Classic Software, Inc.
7665 Athenia Drive
Cincinatti, OH 45244 USA
Phone: 513.232.6764
Sales: 800.677.2952
Fax: 786.221.2553 or 888.456.3464