Re: OPNQRYF mixed results

["Shannon O'Donnell" <ORION@xxxxxxxxxxxxxxx>]

post the OPNQRYF code here so we can look at it.

John Bussert wrote:

> I am having a strange problem that I would like to know if anyone else is
> experiencing.  At one client (seems to be only one...) we have some reports
> that use OPNQRYF, that select records and print them.  Fairly conventional,
> there is some selection and sorting going on in the query, but nothing
> extravagant.  The problem we are having is that one day I can run the
> reports and the next day, run the same report (on history not current data),
> and the numbers change.  Actually, what I think is happening is that some
> records are not being selected in one and they are on the other.  We can
> compare the identical reports run on different days, and see that there are
> records not on one and on the other.
>
> I would almost say that it seems, OPNQRYF is not picking up all records on
> one, but later it does.  Unfortunately, this is not something we can
> duplicate until it happens, then running the report again - it gets fixed
> (the records show up).
>
> They are current on PTF's (as of a couple of months ago) on 4.3.  Has anyone
> else seen or heard of anything like this?
>
> Thanks
>
> john
>
> John Bussert
> jbussert@stecnet.com
> Swift Technologies, Inc.
> 847-289-8339
> 847-289-8939 fax
>
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: david@midrange.com
> +---

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---