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