DISPLAY USING

[ruimgp]

Hi, I want to display some information from a CURSOR but i get a lot of spaces, how do i eliminate these blanks ?

example

DEFINE rec_C1 RECORD
field1 LIKE table.field1, (integer)
field2 LIKE table.fiedl2, (smallint)
field3 LIKE table.fiedl3 (datetime year to second)
END RECORD

(...)

FOREACH cur_C1 INTO rec_C1.*
--this way comes out | 1234| 0|

IF rec_C1.field3 < input_date
THEN DISPLAY rec_C1.field1,&quot;|&quot;,rec_C1.field2,&quot;|&quot;

--this way comes out |1234||

DISPLAY rec_C1.field1 USING &quot;<<<<<<<<<&quot;,&quot;|&quot;,rec_C1.field2 USING &quot;<<<<<<<<<&quot;,&quot;|&quot;

using 9 < (integer) or in case of field2 using both 9< and 5<(smallint) the second field comes completely blank ...

Thanks

 

[ruimgp]

If concerns to anyone the correct use is:

DISPLAY field USING &quot;<<<<<<&&quot;

the number of <<<<< is based on
integer 9
smallint 5

and the key is the &quot;&&quot; who forces data to be displayed.
Bye

 

[freddie1]

Note that USING &quot;<<<<&&quot; won't work for negative values.
Try USING &quot;-<<<<&&quot; for negative values.