Field NUMERIC(9, 0) in Firebird

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
rc
Posts: 11
Joined: Thu 24 Dec 2009 13:46
Location: France

Field NUMERIC(9, 0) in Firebird

Post by rc » Thu 24 Dec 2009 13:59

Hello ! I am testing Unidac Components Version 3.00 for Delphi 2010.

When I connect TUniTable to a Firebird 1.5 DataBase, fields of defined as NUMERIC(9, 0) are considered as TFloatField instead of TIntegerField.

What can I do to resolve this problem ?

Thank you !

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Fri 25 Dec 2009 08:24

InterBase provider supports only TFloatField, TBCDField, and TFMTBCDField for NUMERIC. Use INTEGER type in the database for TIntegerField.

rc
Posts: 11
Joined: Thu 24 Dec 2009 13:46
Location: France

Post by rc » Mon 04 Jan 2010 07:41

Thank you for your answer. But it will be a problem for existing databases :(

Post Reply