|
|
 |
Programming tips on integrating the BDE API with Delphi to create
robust database applications.
32 Bit Examples
Detailed description of download types for 32 Bit Utilities is available here.
Sortable query component with source (Created 03/11/98, Size 14,324 bytes)
This compnent with example will allow you to sort the result of a query by any field in the resultant
table. Indexes do not need to exist on the fields. Result set must be canned (Dead) but a TUpdateSQL
component can be used to update the underlying table. NOTE: This component will also compile
within Delphi 2, but the sort event will not occur when clicking on the grid.
InterBase 5: new user functions with source (Created 02/12/98, Size 203,840 bytes)
InterBase 5: new user functions with source (Package Version) (Size 28,489 bytes)
InterBase 5: new user functions (Packaged EXE) (Size 39,936 bytes)
Displays the functionality of the three new InterBase 5 functions (isc_add_user, isc_delete_user and isc_modify_user).
This program can be used as an example of how to manipulate the password database for InterBase servers via InterBase API.
Included are simple to use functions that encapsulate the InterBase API functions.
NOTE: These are new InterBase 5 functions, threrefore this example cannot be used
with InterBase 4.21 or earlier.
Stored procedure component with source (Updated 01/26/98, Size 6,366 bytes)
This example allows the user to call a stored procedure in any of the three BDE API possible ways.
This component can be used to workaround problems such as the MSACCESS crash with queries that
have parameters. Anyone who wants to call procedures from Delphi with BDE API calls should look
at this example.
BDE API examples
These examples are created in hopes to bring you more effective BDE API examples.
More examples are on the way!
Table change notification component with source (Size 3,737 bytes)
This sample component does all the BDE API work for you to give notification when a Paradox table
has changed. Fully configurable; check interval time and custom event allows you to do anything you
want when the table has changed. Simply install the new TTable component (TRegisterTable in
RegisterTable.pas) and compile the included project. This component will work with all table types,
but will only use the callback with Paradox table types.
BDE network installation example with source (Size 289,818 bytes)
This example allows a user to setup the BDE and SQL Links on a client machine without having
to install the BDE and SQL Links to the client. Registry entries are placed into the client
machines so that the client can access a network version of the BDE. Two programs are included:
one which helps configure the .INI file that is necessary to create the registry entries, and
another program that shows how the methods work to create the registry entries.
NOTE: Using this non supported example, or any method within it, does not violate your
Borland No Nonsense License Agreement. Delphi 3 compiled.
Create an InterBase database with source (Size 223,593 bytes)
Create an InterBase database with source (Package Version) (Size 12,908 bytes)
Create an InterBase database (Packaged EXE) (Size 19,968 bytes)
The BDE cannot create an InterBase Database file (.GDB). Before, the .GDB file would need to
be sent along with the program. This example will create a database file from within a
Delphi application.
BDE configuration file API (Size 238,642 bytes)
This API allows the Delphi2 programmer to achieve all the functionality of Borland's BDE
Configuration Utility. Functions such as adding ODBC drivers, adding aliases, merging two
configuration files, altering and adding new parameters, can all be done with this API. No
help file is available for the API as of now. Included is a comprehensive Delphi2 example
program along with dbicfg.int interface unit.
WARNING: This API is not supported by Borland. Borland does not guarantee that this
API will be forward compatible. This API is for 32 Bit BDE versions 3.0, 3.10, 3.11, 3.12,
and 3.5.
Paradox table alter with source (Updated 5/20/97, Size 206,568 bytes)
Paradox table alter with source (Package Version) (Size 19,1368 bytes)
Paradox table alter (Packaged EXE) (Size 28,160 bytes)
In some cases, it might be useful to change the version, block size or strict integrity of
an existing Paradox table. Before, the table had to be recreated, and data moved from the
old table to the new. This is not the case with this program. Included is source to build
the project and a UI to the procedures needed.
In-Memory table example with source (Updated 02/17/98, Size 230,760 bytes)
In-Memory table example with source (Package Version) (Size 15,422 bytes)
In-Memory table example with source (Packaged EXE) (Size 22,528 bytes)
This examples takes a table, places all the information into an in-memory table, and then
displays all the information in a string grid.
Paradox table repair with source (Updated 11/24/96, Size 148,839 bytes)
Paradox table repair with source (Package Version) (Size 17,624 bytes)
Paradox table repair with source (Packaged EXE) (Size 28,672 bytes)
This program will verify and rebuild Paradox version 7.x or less tables. This application is also available via
BC++ 5.0 OWL and
CBuilder source code.
Add/remove Paradox master and auxiliary passwords (Size 198,711 bytes)
Add/remove Paradox master and auxiliary passwords (Package Version) (Size 32,057 bytes)
Functions are in a separate unit for easy integration into other programs. Includes small
password utility and example table.
Access the ODBC API through BDE32 (Size 2,221 bytes)
In some cases, the need to make direct calls to the ODBC API is desirable. This can be done
while also keeping your data aware controls. This example makes a simple call to
SQLGetInfo and displays information.
Database error handling example: (Size 11,271 bytes)
This example displays all information from an EDBEngineError or EDatabaseError exception. The example
be easily integrated into existing database programs by using the dbengine unit included. Also
displays native errors from SQL Servers.
16 Bit Examples
Access the ODBC API through BDE16 (Size 2,092 bytes)
In some cases, the need to make direct calls
to the ODBC API is desirable. This can be done while also keeping your data aware
controls. This example makes a simple call to SQLGetInfo and displays information.
Table copying control (Size 5,142 bytes)
This control uses the BDE function DbiCopyTable. DbiCopyTable will copy a table of any type to the same
type with a different name. Indexes are also copied with non-SQL based tables. This does work
with SQL Databases. Performance increases in the range of 200% - 400% are not uncommon. Here
is an example (Size 1,692 bytes) of using this
fast control.
Table packing control (Size 6,493 bytes)
This control uses the BDE functions DbiPackTable and DbiDoRestructure. This utility works only with
PARADOX and dBASE tables. Packing a table removes unwanted (deleted) records from a table
therefore restoring hard disk space. This cannot be done with Delphi controls; only this
control will give you full table packing functionality! Here is an
example (Size 1,590 bytes)
of using this control.
Simple filter example (Size 5,439 bytes)
This example restricts the cursor movement on a table. Filters are fast, flexible, and can be used
without indexes.
Download File Descriptions
If there is more than one download option available for a particular utility, this section will
help you determine which download is best for you.
- Download does not contain the keyword "package" in the jump
- This is a Delphi 2 example but will also compile with Delphi 3
- Source will compile with Delphi 2, if available
- If the program needs the BDE, the version must be 3.00 or greater
- Download conatins the keyword "download package" in the jump
- This is a Delphi 3 example making use of Delphi 3's packages. This makes the
download much smaller
- Delphi 3 must be installed or the .DPL (Delphi Package Library) files exits
on the machine
- Source will compile with Delphi 3 only
- If the program needs the BDE, the version must be 4.00 or greater
- Download conatins the keyword "download executable" in the jump
- This is a Delphi 3 executable file using packages
- Delphi 3 must be installed or the .DPL (Delphi Package Library) files exits
on the machine
- Source is not available with this download type
- If the program needs the BDE, the version must be 4.00 or greater
The following E-Mail address is intended for questions or problems with the
current page only. US developer support questions should be handled through
any of the Borland Assist
options. Non-US developer support should be handled through an
international Borland office in your area.
bde_admin@inprise.com
|
|
