ftInteger, ftBCD and ftFMTBCD types

ftInteger, ftBCD and ftFMTBCD types

Postby ralphera » Thu 27 Jan 2011 10:52

Want to buy the driver and I have a question:
Currently working with Firebird and need to maintain compatibility with it and I need the fields NUMBER <10 are "ftINTEGER" AND also that the fields NUMBER (18,4) are "ftFMTBCD.
Is it possible?
Posts: 1
Joined: Thu 27 Jan 2011 10:45

Postby AlexP » Fri 28 Jan 2011 12:00


Yes, it is possible.
To get such behavior you should set the following options like:

Delphi 2006 and lower IDE versions

procedure TForm1.SQLConnection1AfterConnect(Sender: TObject);
coIntegerPrecision = TSQLConnectionOption(205);
coEnableBCD = TSQLConnectionOption(102);
SQLConnection1.SQLConnection.SetOption(coEnableBCD, Integer(True));
SQLConnection1.SQLConnection.SetOption(coIntegerPrecision, Integer(10));

Starting with CodeGear RAD Studio 2007

SQLConnection.Params.Values['EnableBCD'] := 'true';
SQLConnection.Params.Values['IntegerPrecision']:= '10'

For more information, please see the Readme.html help file.
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Return to dbExpress driver for Oracle