Re: OPNQRYF - Sort by a calculated field

["Carel Teijgeler" <coteijgeler@xxxxxxxxx>]

Peter

Is the mapfield OBPCT a field in the format, which seems to be file MEINVDTL. 
Or in other words: is OBPCT a field in the file itself?

If not, map the field to an existing field in the file, that is not used in the 
processing of that file.

Just a thought.

Regards,
Carel Teijgeler

*********** REPLY SEPARATOR  ***********

On 16-12-02 at 15:59 Peter Vidal wrote:

>Very simple question but I do not know what I am doing wrong here:
>
>OPNQRYF FILE((MEINVDTL)) QRYSLT('OBQTY *GT 0')
>KEYFLD((*MAPFLD/OBPCT))
>MAPFLD((OBPCT '(OBSTKVAL/OSTKVAL)*100' *ZONED 9 3)))
>
>I want to sort by this field that I am calculating here (*ASCEND)
>but is crashing when I get here.
>
>I have glasses and none of my four eyes are helping me here.
>
>Your help is greatly appreciated.