Page 1 of 1

force ftNumber into ftFloat

Posted: Wed 25 Aug 2010 14:35
by easyblue
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?

Posted: Mon 30 Aug 2010 14:02
by bork
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.