|
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: midrange-l-admin@midrange.com | [mailto:midrange-l-admin@midrange.com]On Behalf Of rob@dekko.com | Sent: Monday, December 03, 2001 12:15 PM | To: midrange-l@midrange.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.
This mailing list archive is Copyright 1997-2024 by midrange.com 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.