Mystery record?

[Neil Harvey]

John's advice is good. I've been there many times:)
PowerHouse is generally so consistent on MPE/iX that I'd suspect something
else.

First, follow John's file equation theory. Break Quiz before it exits, and
listeq. I once found a file equation hard coded into the PowerHouse command
files, set at the start and reset at the end - someone's idea of
testing.....

Change your rep statement to rep all and look for differences.
If you have Suprtool, open the same database that control is supposed to be
in, and get control, l, x
If you have mpex, try a %listf <database with control>, db

There MUST be a reason for this strangeness.

But above all, please let us know when you do find the reason.

Regards

Neil


-----Original Message-----
From: Pickering, John (NORBORD) [mailto:PICKERIJ@norbord.com]
Sent: 10 August 2000 07:51
To: 'Janet Thorp'; powerh-l@sphere.swau.edu
Subject: RE: Mystery record?



Are you sure that Quiz is opening the same base as Query? Query has the
advantage of requiring you to enter the actual base name and group. Quiz
uses what the dictionary says and obeys file equates. So, are you using the
correct dictionary? What does the dictionary definition of "control" specify
as the base name for the database and the open name for the record? Are
there any file equates pointing off perhaps to some molested test version?
Does Qtp give the same results (change the report statement to a subfile
statement) ?

John "just guessing" Pickering

> -----Original Message-----
> From:	Janet Thorp [SMTP:JanetThorp@performing-tech.com]
> Sent:	Thursday, August 10, 2000 1:12 PM
> To:	powerh-l@sphere.swau.edu
> Subject:	Mystery record?
> 
> 
> Hi,
> What would cause Quiz to read a record twice?  A client has a dataset
> called
> CONTROL that has 1 record in it.  Here's what happens:
> 
> use purgeit
> > access control
> > define curr-fisc = current-fiscal
> > report curr-fisc
> > go
> 
> 08/07/00              XYZ Company           PAGE   1
> 
>   CURR-FISC
> 
>       2001
>       2001
> 
> ?
> 
> Records selected:  2
> Lines printed:     4
> Pages printed:     1
> 
> >
> 
> In query there is only one record (as it should be)...any ideas???
> TIA,
> Janet
> 
> 
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> =
> 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.