TIntegerField X TFloatField

[fbnunes]

Hi,

I have a SQL like this:
"Select field1, field2 from table1"

2 TIntegerFields ( in Delphi ) were generated

If i change the SQL to:
"Select field1, 0 as field2 from table1"

field2 will be TFloatField. Why ?

I need the TFields in design-time. How can i generate a "0" value as a TintegerField ?

 

[Marco Kalter]

Oracle reports this field as a number(38), which is of course too big for an integer. If you set TOraceSession.Preferences.IntegerPrecision to 38, all numbers that have a scale of 0 will be treated as integer fields. This may affect the rest of the datasets in your application of course.

------------------
Marco Kalter
Allround Automations