Re:RE: Passing parameters to a query

Another way would be to create a PF, load parms into it, then use this file in
the query to pull data from other file(s).

____________________Reply Separator____________________
Subject:    RE: Passing parameters to a query 
Author: <RPG400-L@midrange.com>
Date:       6/22/99 10:07 AM

I never could figure that out.  I use opnqryf to select data and build in
qtemp.  Then run query over qtemp to format & print report.  No selection
are then coded in the query.

Christopher K. Bipes                mailto:ChrisB@Cross-Check.com
Sr. Programmer/Analyst                mailto:Chris_Bipes@Yahoo.com
CrossCheck, Inc.                    http://www.cross-check.com
6119 State Farm Drive                Phone: 707 586-0551 x 1102
Rohnert Park  CA  94928                Fax: 707 586-1884



-----Original Message-----
From: keshava narasimha [mailto:anandthirta@hotmail.com]
Sent: Tuesday, June 22, 1999 9:31 AM
To: RPG400-L@midrange.com
Subject: Passing parameters to a query


Hi there !


How can you pass parameters to a query?


Thanks.

Keshav


______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the RPG/400 Discussion Mailing List!  To submit a new         *
* message, send your mail to "RPG400-L@midrange.com".  To unsubscribe   *
* from this list send email to MAJORDOMO@midrange.com and specify       *
* 'unsubscribe RPG400-L' in the body of your message.  Questions should *
* be directed to the list owner / operator: david@midrange.com          *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the RPG/400 Discussion Mailing List!  To submit a new         *
* message, send your mail to "RPG400-L@midrange.com".  To unsubscribe   *
* from this list send email to MAJORDOMO@midrange.com and specify       *
* 'unsubscribe RPG400-L' in the body of your message.  Questions should *
* be directed to the list owner / operator: david@midrange.com          *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

 

Received: from Kitten.mcs.com [192.160.127.90] by gbc.com (ccMail Link to SMTP 
R8.20.00.25)
        ; Tue, 22 Jun 1999 13:14:08 -0600
Return-Path: <uucp@Uucp1.mcs.net>
Received: from uucphost.mcs.net (Uucp1.mcs.net [192.160.127.93]) by 
Kitten.mcs.com (8.8.7/8.8.2) with ESMTP id NAA05569; Tue, 22 Jun 1999 13:08:36 
-0500 (CDT)
Received: (from uucp@localhost)
        by uucphost.mcs.net (8.8.8/8.8.8) id NAA17572;
        Tue, 22 Jun 1999 13:08:33 -0500 (CDT)
Received: (from majordom@localhost)
        by midrange.com (8.9.3/8.9.3) id MAA32192
        for rpg400-l-outgoing; Tue, 22 Jun 1999 12:16:02 -0500
Received: (from uucp@localhost)
        by midrange.com (8.9.3/8.9.3) with UUCP id MAA32076
        for RPG400-L@midrange.com; Tue, 22 Jun 1999 12:07:33 -0500
Received: from mailsrv.CROSS-CHECK.COM (mailsrv.cross-check.com 
[208.150.158.251])
        by uucphost.mcs.net (8.8.8/8.8.8) with ESMTP id MAA13494
        for <RPG400-L@midrange.com>; Tue, 22 Jun 1999 12:04:32 -0500 (CDT)
Received: by mailsrv.cross-check.com with Internet Mail Service (5.5.2448.0)
        id <N113RS9C>; Tue, 22 Jun 1999 10:07:48 -0700
Message-ID: <E459D7CB5EFFD211A67F00600898F41306304D@mailsrv.cross-check.com>
From: Chris Bipes <ChrisB@cross-check.com>
To: "'RPG400-L@midrange.com'" <RPG400-L@midrange.com>
Subject: RE: Passing parameters to a query
Date: Tue, 22 Jun 1999 10:07:46 -0700
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2448.0)
Content-Type: text/plain;
        charset="iso-8859-1"
Sender: owner-rpg400-l@midrange.com
Precedence: bulk
Reply-To: RPG400-L@midrange.com
X-List-Name: RPG/400 Discussion Mailing List (RPG400-L@midrange.com)