visual fox pro registros duplicados vfp
* 1er metodo
Set ENGINEBEHAVIOR 70
SELECT * FROM Acnpagos WHERE Acnpagos.c_nropag in (SELECT TOP 10 Acnpagos.c_nropag FROM Acnpagos ORDER BY Acnpagos.c_nropag GROUP BY Acnpagos.c_nropag HAVING COUNT(Acnpagos.c_nropag)>1)
LOCATE FOR Acnpagos.c_nropag='GA14030275'
* 2do metodo
SELECT Acnpagos.c_nropag, COUNT(*) FROM Acnpagos GROUP BY Acnpagos.c_nropag HAVING COUNT(*) > 1