Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Deletion of Duplicate Records
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00435962
Message ID:
00435995
Views:
14
>>I need some assistance with the deletion of duplicate records. I am working with a free table (no primary keys).
>>
>>What I am trying to accomplish is finding a prg to seek out all the duplicate values in the invoice_no field and delete them.
>>
>>can someone help me out?
>I'm not sure if this is exactly what you're looking for but it might help:
>USE sometable
>INDEX ON invoice_no TO test UNIQUE
>COPY TO newtable

Here's a variation I've used:

USE sometable
DELETE ALL
INDEX ON invoice_no TO test UNIQUE
RECALL ALL
PACK
kenweber
GCom2 Solutions
Microsoft Certified Professional

Previous
Next
Reply
Map
View

Click here to load this message in the networking platform