Subject Re: [IBO] Integer Field Manipulation
Author Svein Erling Tysvær
>select (pcost/100) as rcost from .....
>
>and this worked, with the value correctly displayed. On the new sytem
>(using iboDatabase and iboQueries) the same query simply displays the
>word 'rcost' in the data field. Using select cast(pcost as real)/100 as
>rcost from ... doesn't work either (claims the field doesn't exist).

Strange - are you sure this doesn't work?

I just tried using IB_SQL with similar queries, and the only trouble I
found was that unless I cast the field, the result is an integer.

So my guess is that this is either a problem with QuickReport, the TDataset
Compatible components of IBO (doesn't quite make sense), your particular
version of IBO or something messy in your installation.

Not much help from me I'm afraid,
Set
-former UMIST graduate (1992)