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