I won't say I get OPNQRYF right the first time, every time (why I also use
&QRYSLT).  But I have pretty good luck by typing complex selects in without
any variables, first.  For example:


Then I strip out the variables, and separate the strings:

CHGVAR &QRYSLT ('LSTCHG *GE "' *cat XXXXXX *cat '" *AND LSTCHG *LE "' *cat
XXXXXX *cat '" *AND RECTYP = "M"')

Which then leads to:

CHGVAR &QRYSLT ('LSTCHG *GE "' *CAT                   +
               &BEGUPD *CAT '" *AND LSTCHG *LE "'     +
               *CAT &ENDUPD *CAT '" *AND RECTYP       +
               = "M"')

(I never did see the problem, BTW, unless LSTCHG was numeric.)


| -----Original Message-----
| From:
| []On Behalf Of
| Sent: Monday, December 03, 2001 12:15 PM
| To:
| Subject: RE: OPNQRYF problem
| <SNIP>
| ...since I never get
| OPNQRYF right the first few times anyway.
| Who does?  This is why I like SQL better.
| Rob Berendt
| ==================
| "They that can give up essential liberty to obtain a little temporary
| safety deserve neither liberty nor safety."
| Benjamin Franklin

<huge snip of prior messages>

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.