Cast Function

[shannonwrege]

I am trying to write a query like this:

select cast(0 as smallint) from dual

I am attaching a dataset to this and I need the field to be of type TIntegerField but it is always a TFloatField.

How can I force the dataset to expect an integer from a select query where I want a default value of 0?

Thanks,
Shannon

 

[Marco Kalter]

The precision reported by Oracle for this field is 38 digits. Therefore the TOracleDataSet treats it as a TFloatField. You will need to query a field with a precision of 9 or less to enforce a TIntegerField.