QUIZ Reports Zero Records Read

[Brian Schalme]

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.