Using IBX Components with Delphi
The main way to access Firebird (and Interbase) databases is to use
InterBase Express (IBX) components.
IBDataset
Identifying a Database
Using Delphi 5 SP1 with the IBX upgrade,
all 3 of the following methods of identifying a database work with
regular *.exe files
ComputerName:C:\path\Database.fdb
//ComputerName/C:\path\Database.fdb
\\ComputerName\C:\path\Database.fdb
However, only the following works with web server (CGI) *.exe files
ComputerName:C:\path\Database.fdb
The other 2 methods (with slashes) cause various errors.
(This is by design ... it is not an error.)
IBX Updates
The IBX components that come with Delphi 5
will not work in CGI files (web access) and must be upgraded.
In addition, the
IBX update
provides
When you right click an IBDataSet, you now get the Dataset Editor option
(same as Delphi 6 and above)
IBDataSet now contains GeneratorField (but no help)
The IBDatabase component now defaults to SQLDialect 3 (it was Dialect 1 before)
References
-
Introduction To InterBase Express (IBX)
by Bill Todd is a must read.
It actually explains how to use the IBX components ...
in particular IBDataSet.
Notice that the IBDataSet Dataset Editor is NOT available in Delphi 5
(until you update the IBX components
... by default, the editor is available with Delphi 6).
(Notice that, since the article never indicates which version of Delphi it applies to,
there may be additional differences.)
Notice that the Dataset Editor combo box used to select a table will not work
until the SelectSQL property is set and a transaction is assigned.
If you use mixed case, dialect 3 tablenames, don't forget to place them in double quotes.
- Building Applications with IBX
by Jeff Overcash is interesting.
Author: Robert Clemenzi -
clemenzi@cpcug.org