>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
>
Perhaps something like this might work?
SELECT id FROM test11 GROUP BY id HAVING COUNT(*) > 1
ICQ 10556 (ya), 254117