Is it possible that you have TPI on this DB and the indices have a
problem? Perhaps Query did a serial read and Quiz is doing a TPI-indexed
read even though you said REPORT ALL? If you have TPI, try disabling the
DB for TPI and run the Quiz test again. Just a wild guess.

HTH

Janet Thorp wrote:
>
> Query reports 1 record.  Quiz, when ACCESS CONTROL/REPORT ALL/GO reports 2
> records on the first pass, then 1 record on subsequent passes.  Weird.
>
> Also checked for duplicate CONTROL records in the dictionary as well as
> duplicate DUMMY-ZERO (key to CONTROL master dset) - found none.
> janet
>
> >At 06:10 PM 8/7/2000 -0400, you wrote:
> >>Here's a suggestion
> >>>access control
> >>>rep all
> >>>go
> >>
> >>If you still get 2 records
> >>
> >>>QUERY
> >>b=
> >>pw
> >>mode
> >>s=control
> >>f all <key>
> >>r all
> >>exit
> >>
> >>One record of two??  Query won't lie
> >>
> >>
> >>>>> Janet Thorp <[log in to unmask]> 08/07/00 04:55PM >>>
> >>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
> >>