RE: OPNQRYF problem

[Richard Reeve <richreeve@xxxxxxxxx>]

LSTCHG was numeric.....Sometimes it doesn't pay to get
out of bed in the morning, although lately I've been
learning (or in some cases re-learning) a lot of
things.

Thanks.

--- jt <jt@ee.net> wrote:
> 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>
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion
> (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit:
>
http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the
> archives
> at http://archive.midrange.com/midrange-l.
>


=====


__________________________________________________
Do You Yahoo!?
Buy the perfect holiday gifts at Yahoo! Shopping.
http://shopping.yahoo.com