QUIZ Reports Zero Records Read

[Abraham Zwygart]

Hi,
I had problems simular to this and was solved by putting the following two
lines before each pass:
can clear
set default

The settings from pass 1 was messing up pass 2.
Hope this helps
Abraham Z.
----- Original Message -----
From: Brian Schalme <Brian_Schalme@mbnet.mb.ca>
To: <powerh-l@lists.swau.edu>
Sent: Thursday, September 23, 1999 6:53 AM
Subject: QUIZ Reports Zero Records Read


> We have noticed on four occasions that a compiled QUIZ
> program will not produce a report. Yet when we re-compile
> the program and use the very same data, it works. We
> have been unable to reproduce the problem and are
> wondering if this is a known problem.
>
> Environment: PH8.19C5, MPE/iX 5.5 Express Patch 4,
> HP3000/918, IMAGE.
>
> Now I know what you're thinking: :FILE equates and/or
> temporary/permanent file conflicts. This is the first thing we checked.
> There are no :FILE equates pointing elsewhere for the files being
> referenced, and the only version of the subfile is the temporary file.
>
> We have a QTP program that produces a subfile. This
> subfile is then used by a QUIZ program to link to a
> Manual Master, add up some totals, then produce a report.
> There is no SELECT statement in this QUIZ program.
>
> We run the QTP program and it completes successfully. It
> produces a temporary subfile with several thousand
> records in it. We then run the QUIZ program, but it
> reports zero records read, and terminates normally. Of
> note is that the QUIZ program comes back instantly to
> tell us zero records read, as if it really didn't look.
> Yet we can write an ad-hoc QUIZ program to access the
> same subfile during the same session and link to the
> same Manual Master, and we get data.
>
> If we recompile the program, but answer "N" to the
> question of whether we want to replace the compiled
> program that is already there, and do a "GO", we get
> the report we expect.
>
> Here's the best part: We can recompile the QUIZ program
> using the same source code file, run it, and it produces
> a 20-some page report. It works fine.
>
> There has been no structural change to the Manual Master.
> The two of us here are the only ones working with it.
>
> We tried to duplicate the conditions as accurately as
> possible. We used the same compile job that created the
> two problem programs. We then ran the QTP program, and
> then the QUIZ program - it produced the report we were
> expecting. We checked for conflicts between temporary
> and permanent subfiles - none. We check for :FILE equates
> pointing elsewhere - none.
>
> I have noticed this with three other QUIZ programs. I
> was even able to replicate the problem once using ad-hoc
> QTP and QUIZ programs using PH8.19C4 in August. Same
> procedure: write a QTP program to make a subfile, then
> write a QUIZ program to read it. The first time I ran
> the QUIZ program it reported zero records read. I write
> the program again (access *xxx, rep all, go), and run
> it, I get data.
>
> If this only happened once, I could write it off as a fluke (cosmic
> dust, increased solar activity, etc.). But four times on different
> occasions? I'm wondering...
>
> Any clues?
>
> Brian Schalme
> Airspeed Consulting
> bschalme@mbnet.mb.ca
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
=
> 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.