Index tag is the problem; I didn't realize that it was set. Thank you.
>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
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham