>I need to find repeated records in a table
>
>I am using scan + count as below, but looks like count stops scan process
>Scan does not go beyond the first record
>
>

>SELECT TEST11
>
>   SCAN
>   STORE TEST11.ID TO VERR
>    COUNT FOR TEST11.ID = VERR TO VERIX
>      IF VERIX > 1
>  = MESSAGEBOX ("DUPLICATE RECORD" + STR (VERR))
>     ENDIF
>       ENDSCAN
>

Are you using SCAN loop because you have un-commited changes?