Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Scan + count
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Scan + count
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01322689
Message ID:
01322689
Views:
72
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
Next
Reply
Map
View

Click here to load this message in the networking platform