Puzzler of the day - 5.0 Windows Setup

Kenneth Brody kenbrody at spamcop.net
Tue May 3 14:15:39 PDT 2011


On 5/3/2011 4:49 PM, Nancy Palmquist wrote:

[... Computers A and C work.  Computer B doesn't properly select records...]

> When it is broken, here is what I get.  Output prints two lines for each
> record (doubling the statement balance) and it starts the output at
> billing account 05575 instead of 05502 (all data before 05575 is gone).
[...]

I was going to suggest the possibility that computer B was pointed to a 
different data set, until you wrote:

> Now if I have Computer B, run from 05502 to 05574 - it works correctly.
> If I have Computer B, run from 05576 to 05683 - it works correctly.
> If I have Computer B, run just 05575 - it works correctly.
>
> I do not use lookup (dash) in the programming so I am not roaming
> around.  I do use the PRINT command but that would not cause the index
> to include the duplicate records since that happens on the generating
> side not sort/select side.
>
> To my experience, I can say SELECT - 20 times in a scan table and I
> still only get one selection.

Correct.

> But just to make sure, I did check and I
> only issue the SELECT command once, without condition, so it is not
> repeating that.
>
> BTW - No associated fields are used in this file.  Eliminate that
> possibility.
[...]

How about having your sort/select processing log each record number 
processed, along with "selected"/"not selected", and see what you get?  How 
does computer B compare to the ones that work?

-- 
Kenneth Brody


More information about the Filepro-list mailing list