Using Qdesign to Create a Select

[georgia miller]

Colin,

I am also on an HP3000 with MPEix, PH729.C3

I don't think you can create a subfile in Quick.  I do believe you can update 
or write to a subfile that is already defined with Quick.  Page 503 and 504 
of the 7.29 Qdesign Manual states that a File can be *subfilespec (FILLE 
*subfilespec)
*subfilespec = The name of the Subfile. *Limit: The subfile must exist; 
QDESIGN cannot create subfiles.  I know that I have created a keyed subfile 
with Quiz or Qtp and then used it as a lookup/reference file in Qdesign.

What we do is use Qdesign as a submit screen that accepts the variables, then 
creates a job stream with the entered variables, then streams the job.  The 
job stream is also saved in a submit group, for later reference or if the job 
needs to be resubmitted.  This works very well.  Actually you could also run 
Quiz inside of the Qdesign and pass variables to the Define - Parm 
statements.  This is done in the Update Procedure of our Submit screens.  
This could also be done in a designer procedure.  We have a file set up in 
the dictionary called SUBMIT-FILE with one field called SUBMIT-LINE.  The 
Submit-file is purged and created. Then all of the statments in the Job 
stream are written to this file with lets and puts.  Then the file is closed 
and streamed within the Qdesign Update procedure. The thing I like about the 
submit screens for the users entering variable data for reports, jobs etc, is 
that you can do lookups, have search screen available, and other complex data 
checks.  The screens have help that describe what the report or process does 
and also the fields have help as to what the user needs to enter in the field 
and what it's used for.  Also the selectbox menu type fields work well for 
options on sorts, etc.  These submit screens, let the user choose the 
printer, # of copies, and even time to stream the job.  If you would like an 
example, let me know.

Georgia Miller, Systems Analyst
Email: georgia_miller@gfps.k12.mt.us
Great Falls Public Schools
1100 4th Street South
Great Falls, MT  59405
(406)791-2358
______________________________________________________________________________
_
To: powerh-l@lists.swau.edu
From: COLIN GLASS on Tue, May 5, 1998 2:24 PM
Subject: Using Qdesign to Create a Select


>We are currently using PowerHouse version 7.09 on an HP3000.  I'm
>wondering if I could create a Qdesign screen whose output would be a subfile
>used as a select statement in a Quiz program.  Is this possible without
>creating a new flat file in the PowerHouse dictionary?

>What I would like to do is to ask the user to enter various parameters to
>determine the conditions required to produce mailing labels.  These
>conditions include customer type, in town or out of town, customer using
>Electronic Funds Transfer, etc.

>If there is a way to do this with a subfile, please provide me with an 
example
>of how this can be done.

>Thank you in advance.

>Colin Glass
>Manitoba Liquor Control Comission

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.