Subphyla question

[Rohde Dirk (Van)]

Unix is record 0 as well.

-----Original Message-----
From: Ohmes, Matt [mailto:Matt.Ohmes@COGNOS.com]
Sent: Tuesday, February 29, 2000 2:49 PM
To: 'Scott, Valerie'; POWERH-L@lists.swau.edu
Subject: RE: Subphyla question


Actually you can link to the subfile from your data file. Try this:

ACCESS datafile LINK TO RECORD 1 OF *subfile

SELECT IF dateitem of subfile = dateitem of datafile

Quiz will read the subfile record once and keep it in memory through the
entire run, so it should be quite effecient.  

You didn't say what machine you are on, but the above works for VAX and UNIX
(I believe). If you are on an HP3000, substitute a zero for the "1" in the
ACCESS statement.

Matt

Matt.Ohmes@Cognos.Com
Cognos Corporation
909 E. Las Colinas Blvd.
Suite 1900
Irving, TX  75039
214-259-6200
"Matt doesn't really know anything.  He just likes to pontificate a lot.
We refuse to acknowledge that he works for Cognos or that we have ever
met him or anyone with whom he's ever been associated.  Don't lend him
money and don't let him talk to your sister!" ;-)

-----Original Message-----
From: Scott, Valerie [mailto:vscott@solanocounty.com]
Sent: Tuesday, February 29, 2000 4:30 PM
To: POWERH-L@lists.swau.edu
Subject: Subphyla question


How can I avoid needing a parm prompt entry in all 4 passes of a report? I
am unable to pass the user date range beyond the first report.

I am writing a Quiz program that runs 4 passes of data.
Each pass for data require the same user entered Date range.
I created a one record subfile(a) to accept the PARM PROMPTED date value.
On the first report, I use a USE to run the subfile(a), prompting for the
date.
The remaining reports access other files and append to a separate subfile,
which at the end is sorted and reported by type of record.
I don't believe I can link to my 'date' subfile, because the data file is
driving the reporting.
Once the date range is captured, is there a way to hold the dates,
throughout all four passes?

Thank You,
Valerie
Solano County


 

Thank you,

Valerie Scott


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