×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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/
midrange.com
