Field Value coming back as wrong type

[Cisco Juarez]

Hello,
I have a table column defined as number(10).
I use this column in a dataset. The field for this column is set as Integer. When I open the dataset, I get an error saying something like:
Float Value ...integer expected..

What can be wrong ?

 

[Marco Kalter]

A number(10) cannot be represented by an integer. The 32 bits of an integer cannot hold the 10 digits precision of a number(10). It can be represented by a float field, or you can reduce the precision to number(9).