>>No, unfortunately it's no longer correct way (or never was correct way). It >works in VFP7 and bellow, but would not work in VFP8. It also would not >work in SQL Server or Access.
>
>Thanks for the heads up on this - as I don't want to revisit this code when I move to VF8 in a couple months. In the past I would build a temp unique index to handle this type of situation, and perhaps that is still my best solution.
>
>Mel Cummings

Michel did the transition already Migration - simple enough in two days Thread #751302 Message #751302

As I said, check his recent threads for ideas...

BTW, I have a FAQ here about getting rid of duplicates. I will check it, if it's ANSI complaint...