RE: OPNQRYF looks good, bad results

Make sure the file in the program is also named POMST and is not defined
as keyed.

-----Original Message-----
From: Dan Rasch [mailto:drasch27@xxxxxxxxxxx]
Sent: Monday, March 30, 2009 2:47 PM
To: midrange-l@xxxxxxxxxxxx
Subject: OPNQRYF looks good, bad results


I am trying to use OPNQRYF to choose between four user options to order
a report.

I run the OVRDBF, and it looks fine:



OVRDBF FILE(POMST) SHARE(*YES)



Then, I run one of the four OVRDBF's. Here's one example:



OPNQRYF FILE(POMST) OPTION(*ALL) +

QRYSLT('(POMSTS = ''0'') *AND (POMCPY = 01 )') +

KEYFLD((POMLOC) (POMVNM) (POMVCD) (POMPON)) +

OPTIMIZE(*FIRSTIO) SEQONLY(*YES 10)



It runs with no error, and I am expecting to read the file by:

location, vendor name, vendor code, and PO#

(as coded). What I get is by PO#.



Any ideas?



Thanks,

- Dan

_________________________________________________________________
Internet Explorer 8 - Get your Hotmail Accelerated. Download free!
http://clk.atdmt.com/MRT/go/141323790/direct/01/