I am currently transferring a large system from MySQL to Firebird. On my
original system I have a complex report (QuickReport) that needs to
display an integer field (representing a cost in pence) as pounds. The
query was (simplified):

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).

Can anyone tell me how I need to structure the query to get the result I
need?

Thanks
--
Steve Lee-Woolf
University of Salford
Manchester, U.K.