Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Checking for Duplicates
Message
From
17/02/2004 04:22:58
 
 
To
16/02/2004 09:09:29
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00877622
Message ID:
00877855
Views:
9
Hi,

>
Does anyone know of a simple code that I can check for duplicate records within a table?
>

Looks like most of the solutions offered deal with duplicate fields. For duplicate records try something like:
SELECT RECNO() rec, SYS(2017) checksum from TableX INTO CURSOR myCursor
SELECT * FROM myCursor GROUP BY checksum HAVING COUNT(*) > 1
Regards,
Viv
Previous
Reply
Map
View

Click here to load this message in the networking platform