>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
>
select test11.id, count(*) as cnt from test11 group by 1 having cnt > 1
Your scan fails for you are moving the pointer (with count) inside the scan, you should save the recno before count and restore it after count to be able to use it, which of course will have a lot of overhead
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges
