force ftNumber into ftFloat

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
easyblue
Posts: 64
Joined: Wed 02 Feb 2005 13:02
Location: Shanghai

force ftNumber into ftFloat

Post by easyblue » Wed 25 Aug 2010 14:35

Hello

My Oracle table has many field of ftNumber with length set to 22.

However, actually all the data stored actually are of type Integer or LargeInt.

And after SQL, I will have many ftNumber type fields, naturally.

But since I want to draw some TChart, so I now need manually cast hundreds of them into Float type.

So is there any simply way to force ftNumber be returned as ftFloat?

bork
Devart Team
Posts: 649
Joined: Fri 12 Mar 2010 07:55

Post by bork » Mon 30 Aug 2010 14:02

Hello

Try to set the TOraSession.Options.EnableIntegers and TOraSession.Options.EnableNumbers options to False. In this case all fields with the NUMBER data type will be created as TFloatField.

Post Reply