Re: OPNQRYF - QRYSLT

["Tony Smithurst" <TonyS@xxxxxxxxxx>]

<Snip>
>THIS DOESN'T WORK

<Snip>
>OPNQRYF FILE(pestpr) QRYSLT('WNPDTP1E *EQ &FRMDTE')

Try

OPNQRYF FILE(pestpr) QRYSLT('WNPDTP1E *EQ "' *CAT &FRMDTE *CAT '"')

or you might have to use another variable to contain the entire selection
string, I can't remember off the top of my head, something like:

CHGVAR &QRYSELECT ('WNPDTP1E *EQ "' *CAT &FRMDTE *CAT '"')
OPNQRYF FILE(pestpr) QRYSLT(&QRYSELECT)

ie. substitute the content of the variable into the selection sting. Be
careful of the double and single quotes there, use your cursor to determine
which is which in this message. I think your way was comparing the date to
the alpha value of "&FRMDTE" and not the date content of the variable itself

HTH
Tony

Ps. I think the same thing might apply to your second example too.

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the RPG/400 Discussion Mailing List!  To submit a new         *
* message, send your mail to "RPG400-L@midrange.com".  To unsubscribe   *
* from this list send email to MAJORDOMO@midrange.com and specify       *
* 'unsubscribe RPG400-L' in the body of your message.  Questions should *
* be directed to the list owner / operator: david@midrange.com          *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *