Using Qdesign to Create a Select

[Hans Hendriks]

COLIN GLASS <cglass@mlcc.mb.ca> asked:

>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.


You don't need a subfile, a regular MPE file will do. Here's a quick sample
I cobbled together:

screen test menu
temp start-date char*8
temp end-date char*8
temp prompt char*40
define D-CMD char*80 = "ECHO if Start-date !> " + start-date &
  + " and end-date !< " + end-date + " > mytemp"
title "Creating Use File Demo Screen" centered
skip 2
field prompt
field start-date
field end-date
procedure initialize
begin
  let prompt = "Enter a start-date (YYYYMMDD)"
  display prompt
  accept start-date
  let prompt = "Enter an end-date (YYYYMMDD)"
  display prompt
  accept end-date
  run command D-CMD
end
build

It could use some polishing, but you get the idea ....

This will create a temporary MPE file, which you can "use" from within your
Quiz report. It will be recreated for each use, and is session-specific so
shouldn't cause naming conflicts for multiple concurrent users.

HTH.

/Hans
|----------------------------------------------------------------------
| Hans Hendriks                 Robelle Consulting
| http://www.robelle.com/~hans
| hans@robelle.com        personal: hans@cheerful.com


= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.