Accessing Pervasive.SQL With Perl
Page Last Modified: 20/11/12
Win32::API was created by Aldo Calpini, is maintained by Cosimo Streppone, and is available on CPAN and as part of ActivePerl for Windows. It allows you to call Windows DLLs from Perl provided you know the parameters required and the expected return values and is therefore a low-level interface. It is a useful fallback when you do not have a friendlier (and usually safer) XS to call for the required functionality.
Pervasive.SQL can be accessed by it's own low-level API (still referred to as the Btrieve API after the earlier name of the database system) supplied via the corresponding Pervasive DLL. This DLL, W3BTRV7.DLL, contains a number of functions - the most commonly called one is BTRCALL which is used with different operation codes and parameter combinations to perform the various database operations, such as:
Get first record (physical position or via specific index)
The Btrieve API was the original method of calling the database and is generally still the fastest. However, setting up complex queries has to be done entirely via the application's code, with none of the luxuries of SQL and database optimization entirely down to the application programmer's knowledge of the database schema, e.g. what indexes are available.
All content on this site is copyright