Classic Data Control For Btrieve Enterprise Edition™
The most advanced tool for Btrieve database development
The Classic Data Control for Btrieve Enterprise is a high performance ActiveX (OCX), data
access control for 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 data aware controls.
The programmable interface of the Data Control is modeled after ADO. So you get all of the familiar
properties and methods like MoveFirst, MoveNext, FindFirst, FindNext, Filter, Seek, Bookmark, RecordCount, etc.
Around this we extended other methods and properties that open up access to all of the underlying
features of Btrieve and Pervasive SQL. Things like OpenMode, RecordLocking, Login, Logout, Chunk operations,
etc. And you can use the Data Control for Btrieve Enterprise as either a class or a control.
The Data Control for Btrieve provides superior performance and access to all of
the underlying features of the Btrieve Microkernal Engine. Just
some of the features include; a SQL interface to the Btrieve
extended operations, complete control over indexing, chunk
operations, client ids, all Btrieve record locking, concurrent
and exclusive transactions, extended inserts, and many more.
The data Control Enterprise supports the new Btrieve securoty model of Pervasive 8. It also has special built in support for
Peachtree and Lytec 2005. It can also work directly with DacEasy's own data dictionary files.
Key Benefits
-
Supports ANY and ALL versions of Pervasive SQL and Btrieve.
-
Supports ALL Windows 32 Bit environments.
-
Complete interface to the Btrieve Microkernal API through a comprehensive set of methods and properties.
Automatically converts all Btrieve data types into automation equivalents.
Supported by all applications supporting ActiveX controls, .Net,
Visual Basic, Visual C++, Delphi, Access and Visual Foxpro, etc.
-
Has a core set of methods and properties identical to ADO.
So you will see familiar methods and properties like MoveFirst, MoveNext, FindFirst, FindNext,
Seek, Filter, Bookmark, etc.
-
Binds to any data aware ActiveX (OCX)
control under Visual Basic 6 or less and Visual C++ 4.2 or
later. Get true codeless binding to any data aware control.
-
A true Btrieve and Pervasive SQL tool. This product has been
customized and optimized for Btrieve database
development. Does not rely on ODBC or any other middleware product. So it
is blazing fast, and has minimal dependencies and requirements. There is only
one OCX and support DLL to redistribute.
Features
Provides many value added features:
-
Supports all versions of Pervasive SQL and Btrieve.
Includes a comprehensive set of properties, methods,
and events providing full access to the Btrieve
Microkernal engine.
-
The ability to read and write to Peachtree Accounting data files.
-
Special Support for Lytec 2005 and the new security features of Pervasive 8.
-
Ability to use Lytec practice Files. Just assign the path to a practice file to the DatabaseName property of
the control and it will take care of the rest.
-
The ability to use the DacEasy data dictionary file (deactbl.db and deaccol.db) in place of a standard DDF (file.ddf).
Just set the DatabaseName property to the location deactbl.db file and Open in the same way as with file.ddf.
-
Easy to use design time interface. See just
how easy it is to configure the control using our tabbed
dialog interface.
-
Superior performance. It makes direct calls into the
Btrieve Microkernal. There are no other layers to configure or
slow it down.
-
Small memory and space requirements.
You only need to redistribute one OCX and one support DLL.
-
Minimal dependencies. It only requires the absolute minimum Btrieve Microkernal components.
You cannot use less to read Pervasive SQL or Btrieve file.
-
SQL interface to the Btrieve Extended operations.
-
Supports all 32 Bit versions of Windows.
-
Support for all Btrieve data types: String,
Integer, Float, BFloat, Date, Time, Decimal, Money,
Logical, Numeric, LString, ZString, Note, LVar, Unsigned
Binary, Autoincrement, Numeric STS, Bit, Currency, Timestamp,
WString, WZString, CLOB, BLOB, Pascal Reals, etc. All
Btrieve data types are automatically mapped to automation data types.
-
Support for Btrieve chunk operations.
-
Support for all Btrieve Open modes.
-
Exclusive or concurrent transactions.
-
Supports Btrieve Extended inserts.
-
Use of application specified client ids.
-
Complete control over record locking for data access and transactions.
-
Seek and find operations. Search for records
by any key. Find via SQL syntax. Supports LIKE operator
for text searches.
-
Single and multi-engine modes.
-
Support for Continuous operations.
-
Access to the Btrieve record data as a byte array or through user defined types (UDT).
-
The ability to treat Btrieve records like a
file with methods like SeekRecord, ReadBytes, SetSize,
and WriteBytes. Can be used to store/retrieve images, video and
sound data to/from very large Btrieve records.
Other advanced features
-
Includes 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 8, 2000, 7.x or 6.x (or earlier) format.
-
Frees your from the need for data dictionary (DDF) files.
-
You can perform data binding even if you do not have a DDF.
-
Can be used as either a Class or Control. So you can use it with any tool that
supports CreateObject. You can use it with ASP, VB Script, any VBA enabled application, and
many others.
-
Built in data export capabilities to any delimited or fixed text files. Just set a few properties to format the data
and then invoke the ExportData method.
The Classic Data Control for Btrieve 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 as a Class or Control
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
that 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 products support all Btrieve and Pervasive SQL based applications and tools
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 Dynamics, Solomon, Platinum,
Peachtree, Maximizer, Macess, Lytec Medical and many others. If it is based on Btrieve and/or Pervasive SQL then our products are compatible.
Programming tools supported include .NET, Visual Basic, Visual C++, Access, Visual Foxpro,
Visual J++, ODBC and OLE DB drivers, Active Server Pages (ASP), VBA enabled applications and many other tools and utilities.
All specifications subject to change without notice.
Data Manager for Btrieve and Pervasive SQL, Developers Toolkit for Btrieve and Pervasive SQL,
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.
|
