RE: Passing params to a Query

["Andy Youens" <Andy@xxxxxxxxxxxxxxxx>]

 Mike

Try the following;

You need to define a query management query 

You can put a parameter into query, then run it using query manager. 

The query will not run with the normal options

In the query definition prefix the variables with  a colon (:)

AND/OR  Field             Test   Value
        COMPNO            EQ     :COMPANY
 AND    CONTRACT          EQ     :CONO
 AND    PERIOD            EQ     '02'

This then puts you onto a second screen - point the query back to
itself.

Specify Dependent Value Qualifiers

Type choices, press Enter.

  Qualifier type . . . .   1              1=Query, 2=File

  Query or file  . . . .   SLCORPQ1       Name, F4 for list of files
    Library  . . . . . .     UCRPJBAP3    Name, *LIBL, F4 for list

  For choice 2=File:
    File member  . . . .                  Name, *FIRST, F4 for list

Then in the CL that runs the query - 

OVRPRTF    FILE(QPQXPRTF) PAGESIZE(*N 132)

STRQMQRY   QMQRY(TOOLS/MTHAUDIT) OUTPUT(*PRINT) +
             QMFORM(*QMQRY) ALWQRYDFN(*ONLY) +
             SETVAR((COMPANY &CO) (CONTRACT &CONO))


Regards

Andy Youens

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mike Berman
Sent: 30 June 2004 14:51
To: Midrange Systems Technical Discussion
Subject: Passing params to a Query



I cannot recall if this is possible or not. I would like the user to
select the data range. This is about all that ever changes for an
Unconfirmed Orders report.

Thanks,

Mike 
   
--------------------------------------------------------
Company registered in England, number 2458169 
 
  
FormaServe Systems Ltd 
T: 01908 609500 
E: Info@xxxxxxxxxxxxxxxx 
W: www.FormaServe.co.uk 
 
This message (and any associated files) is intended only for the use of 
midrange-l@xxxxxxxxxxxx and may contain information that is confidential, 
subject to copyright or constitutes a trade secret.  
If you are not midrange-l@xxxxxxxxxxxx you are hereby notified that any 
dissemination, copying or distribution of this message, or files associated 
with this message, is strictly prohibited.  
If you have received this message in error, please notify us immediately by 
replying to the message and deleting it from your computer.  
Messages sent to and from us may be monitored.  
Any views or opinions presented are solely those of Andy Youens and do not 
necessarily represent those of FormaServe Systems. 
--------------------------------------------------------