RECCOUNT() looks at the table header to determine the number of records. That could be corrupt, causing a invalid value to be returned.
Or, there is an index tag being used, so SCAN starts at the logical top of the file and the index is corrupt
Or, the table is corrupt and SCAN thinks it's gone through the entire table, when it really hasn't
>Hi,
>
>I have a weird situation where SCAN does not seem to scan records. Here is summary of what I see in the debugger:
>
>A CursorAdapter cursor has 8 records (I see it in the RECCOUNT( cViewName )).
>
>Then there is code
>SCAN
> *-- code
>ENDSCAN
>
>I thought that SCAN automatically starts with the top record so I am not doing GO TOP. But after ENDSCAN the program proceeds to the next line.
>
>What could be causing it? Or am I missing something simple? TIA
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer