This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
[ Picked text/plain from multipart/alternative ]
in your qry report add another variable called :hidate

and then in the cl,  set the value of :lodate and the value of hidate:

but the *GE should be defined the query itself...


> -----Original Message-----
> From: Dan Rasch []
> Sent: Thursday, May 09, 2002 12:44 PM
> To:
> Subject:      Passing parms to query
> I followed up on the thread earlier of passing parms to a query,
> and the results were good.
> The query command I assembled was this (almost an exact copy from the
> FAQ site):
> SETVAR((LODATE 1011001))
> beautiful, but I tried it with SETVAR((LODATE *GE 1010101))
> and I get the error:
> Too many values in list for parameter SETVAR.
> I looked STRQMQRY up in the manuals (remember them) from V3R2
> and it used the example of VAR1 and VAR2 being SQL statements,
> but gave no indication of where these two variables belonged in
> the QUERY definition.
> The harder I think, the confuser I get.
> Dan Rasch - because if the human species concentrated on the really
> important things in life, there would be a shortage of fishing poles!
> IBM Certified twice....... but still a couple PTFs away from Nirvana.
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email:
> To subscribe, unsubscribe, or change list options,
> visit:
> or email:
> Before posting, please take a moment to review the archives
> at
This e-mail message, including any attachments, is for the sole use of the
intended recipient(s) and may contain confidential or privileged
information.  Any unauthorized review; use, disclosure or distribution is
prohibited.  If you are not the intended recipient, please contact the
sender by reply e-mail and destroy the message.

This thread ...

Return to Archive home page | Return to MIDRANGE.COM home page