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