RE: pass parms to qry400

[Joe Giusto <JGiusto@xxxxxxxxxxxx>]

You could create a 1 field work file and put the value to be selected (using
RPG) in it and write the QRY to join to the work file, selecting only
matching records.  Then just do the RUNQRY normally after prompting for the
selection criteria. 

Joe Giusto II
Patuxent Publishing Company
10750 Little Patuxent Parkway
Columbia, MD 21044
mailto:JGiusto@patuxent.com <mailto:jgiusto@patuxent.com> 
http://www.lifegoeson.com <http://lifegoeson.com> 




-----Original Message-----
From:   Angela Wawrzaszek(EXCH) [SMTP:wawrzaszeka@AUSTEEL.com]
Sent:   Thursday, June 29, 2000 11:11 AM
To:     'MIDRANGE-L@midrange.com'
Subject:        RE: pass parms to qry400

I've sent parms to an SQL before, if you could change the qry to an sql
statement, I'll let you know how.

Angie Wawrzaszek
M.I.S. Department


-----Original Message-----
From: JGracetri@aol.com [mailto:JGracetri@aol.com]
Sent: Thursday, June 29, 2000 9:31 AM
To: MIDRANGE-L@midrange.com
Subject: pass parms to qry400


Does anyone know if you can do the following.

cl pgm
    dcl &item
    dclf screen
    rcvf screen 
    runqry xxxxx parm &item
end pgm

I do not want the user to have access to the select on qry itself.

thank you jeff G.
 


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---