Hello, Precious! Monday, March 11, 2013, 7:54:34 PM, you wrote:
PS> Try to use the dbexpress. Its built in delphi xe2 and already has support PS> in firebird. I do not suggest dbExpress for several reasons: - Embarcadero closes dbExpress (like Borland closed BDE in 2002), and replacement is FireDAC (former AnyDAC). Unfortunately, it is only available for Delphi XE3 Enterprise users, and can be bought by XE3 Professional users (also it can be installed for previous Delphi versions) - dbExpress, like BDE, have almost no transaction control. SQLConnection.BeginTransaction method is nearly useless, because a) it does not support special IB/FB transaction parameters b) it does not allow to start 2 transactions at the same time Thus, I suggest to stay with IBX, or, to buy FIBPlus, or, to upgrade to XE3 and get FireDAC. These are direct access components (instead dbExpress, BDE, ODBC, OLE DB, etc), and have full control over IB/FB API capabilities. Yes, IBX have some incompatibilities with FB, for example, in unicode support (in Delphi 2009/2010, XE-XE3), but it can be easily fixed in IBX sources (like at the end of the article, about Division by zero error in IBX Delphi 2009 http://www.ibase.ru/unicode_faq.html - it's in russian, but code is understandable, and for the text you can use google translate) -- Dmitry Kuzmenko, www.ib-aid.com
