General information
Category:
Coding, syntax & commands
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only