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... tim > -----Original Message----- > From: Dan Rasch [SMTP:email@example.com] > Sent: Thursday, May 09, 2002 12:44 PM > To: firstname.lastname@example.org > 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): > > STRQMQRY QMQRY(TDER3/PASSPARM) QMFORM(*QMQRY) > ALWQRYDFN(*YES) > 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: MIDRANGE-L@midrange.com > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l > or email: MIDRANGE-Lemail@example.com > Before posting, please take a moment to review the archives > at http://archive.midrange.com/midrange-l. 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 mailing list archive is Copyright 1997-2013 by MIDRANGE dot 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 here. If you have questions about this, please contact