Calling quiz from quick passing parameters...

[Edis, Bob]

G'day again Ron

The scenario you pose below may be impossible depending on the nature of the
data in the subfile and the name/s of the record item/s.  For example, if
the value was a date range the link would not work; It would have to be in a
choose statement.

Regards,
Blue

-----Original Message-----
From: Ron Olenic [mailto:ROlenic@spectra-inc.com]
Sent: Tuesday, March 13, 2001 8:00 AM
To: 'Edis, Bob'
Subject: RE: Calling quiz from quick passing parameters...


Hi Bob!

This email is one of those niggling little things that I needed to respond
to before I could concentrate on my own work.  A pox on you!!

When you linked to record 0 of the subfile, I assume that you were still
reading the entire record set of the primary file.  If you had changed the
linkage to 

access *subfile  &
  link to filename

It would at least reduce the number of records read from the primary file,
and hopefully provide a better response than 45 minutes.  However, I still
agree with your original thought, that passing the system variables is more
efficient for a choose or select value.

Ron

-----Original Message-----
From: Edis, Bob [mailto:bob.edis@fleetpride.com]
Sent: Monday, March 12, 2001 5:46 PM
To: 'Ron Olenic'
Subject: RE: Calling quiz from quick passing parameters...


G'day Ron
 
I think that there will be a lot more I/O with this method.  At least on a
HP/UX platform I have experienced poor performance when using the following
syntax:
 
ACCESS filename &
  LINK TO RECORD 1 OF *subfile
 
I was able to reduce a report run time from 45 minutes to 5 minutes by
replacing the subfile linkage with a CHOOSE SYSTEMVALUE statement instead.
 
What has been your experience?
 
Regards,
Blue

-----Original Message-----
From: Ron Olenic [mailto:ROlenic@spectra-inc.com]
Sent: Monday, March 12, 2001 4:34 PM
To: 'powerh-l@sphere.swau.edu'
Subject: RE: Calling quiz from quick passing parameters...


Hi Chris!
 
Here is another way, since you are running version 8, Quick can write to
subfiles.  Create a permanent subfile file in QUIZ, and then declare it as a
file in your QUICK screen.  Write your data to the subfile, and then access
it in quiz.
 
 
Ron Olenic

-----Original Message-----
From: Gassett, Chris [mailto:Gassett@aavid.com]
Sent: Monday, March 12, 2001 5:19 PM
To: 'powerh-l@sphere.swau.edu'
Subject: Calling quiz from quick passing parameters...


I want to be able to run a Quiz report from within a Quick screen, but I
want to be able to pass data from that the screen has already accessed to
the report to choose specific data.  Is this possible and if so are there
any samples out there?  Thanks in advance.
 
PROCEDURE DESIGNER FRM
BEGIN
  RUN COMMAND "quiz auto=$HOMEQUIZ/test.qzs nolist nostatistics"
END
 
 
Powerhouse Ver. 8.13 d3
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.