Rob, 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: CHGVAR &QRYSLT ('LSTCHG *GE "XXXXXX" *AND LSTCHG *LE "XXXXXX" *AND RECTYP = "M"') 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.) jt | -----Original Message----- | From: firstname.lastname@example.org | [mailto:email@example.com]On Behalf Of firstname.lastname@example.org | Sent: Monday, December 03, 2001 12:15 PM | To: email@example.com | Subject: RE: OPNQRYF problem | | | | <SNIP> | ...since I never get | OPNQRYF right the first few times anyway. | <ENDSNIP> | | 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.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.