Subject | Re: [IBO] Integer Field Manipulation |
---|---|
Author | Svein Erling Tysvær |
Post date | 2002-06-25T15:51:44Z |
>select (pcost/100) as rcost from .....Strange - are you sure this doesn't work?
>
>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).
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)