Ken wrote:
>Hello All,
>I'm still new to Informix, so if this one's a nobrainer (sorry)...
>I have a field defined like: real_estate Interger
>It could contain a value such as: 1500.47
>Question is,
> when printing a report I want to display the number as 150047
>No decimal point.
>Is there a somewhat simple way to do this ?
>Thanks in advance for any ideas,
>---------------
>Ken Mccoy
>Applications Prog.
Ignoring the fact that you say you are holding a fraction/decimal in an
INTEGER field, you have neglected to say whether you are writing an ACE
report or 4GL.
Assuming it is 4GL you are interested in, try:
PRINT xyz USING "#####"
I cannot find the manual, so I am not entirely certain, but you should find
a section that gives examples of the various print formats in Volume 1 of
the Informix programmers reference.
Mark Denham
BBC
London, UK
Mark.Denham@bbc.co.uk