Hello again ..

you could also cast the datatype at the backend (here MS-SQL syntax), this has worked also for me ..

select in the view:
"SELECT o.orderid, o.shipvia, o.freight, CAST(o.shipvia*o.freight AS int) AS NonSense FROM orders o"

after this, datatype of column nonsense was "I"

Regards

Christian