ftInteger, ftBCD and ftFMTBCD types

ftInteger, ftBCD and ftFMTBCD types

Postby ralphera » Thu 27 Jan 2011 10:52

Hello,
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?
ralphera
 
Posts: 1
Joined: Thu 27 Jan 2011 10:45

Postby AlexP » Fri 28 Jan 2011 12:00

Hello,

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);
const
coIntegerPrecision = TSQLConnectionOption(205);
coEnableBCD = TSQLConnectionOption(102);
begin
SQLConnection1.SQLConnection.SetOption(coEnableBCD, Integer(True));
SQLConnection1.SQLConnection.SetOption(coIntegerPrecision, Integer(10));
end;

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.
AlexP
Devart Team
 
Posts: 5530
Joined: Tue 10 Aug 2010 11:35


Return to dbExpress driver for Oracle