deleting duplicate records

herpfan · 07-15-2008, 09:41 AM

Hopefully this is the right forum. I have very limited programming skills. Problem: Have a Visual FoxPro table with records > 235,000. I need to delete duplicate records based on 2 fields: If the ID field has more than 1 entry from the same OP then delete duplicates; entries from different OPs to the same ID field are OK. Any information is appreciated.

herpfan · 07-19-2008, 01:55 PM

46 views, no answer. a programmer at work showed me how. Here's the code he used if any are interested:

select *, upper(allt(op)) + '_' + upper(allt(id)) as op_id from "m:\inst\track.dbf" into table "m:\inst\New_1.dbf"

select * from new_1 group by op_id order by op_id into table "m:\inst\new_2.dbf"

**jamiemac2005** · 07-20-2008, 12:59 PM

Sorry for the lack of replys, i would have replied but i have no experience of foxpro nor am i an amazing database coder and can only just work out what's going on from your solution. Thanks for posting the solution =]

Cheers,
Jamey

herpfan · 07-20-2008, 03:49 PM

no apology needed. have seen a few similar requests in asst forums. had a general idea of the logic but not how to do it. His code creates 2 new tables instead of deleting records. 2nd line of code works (I think) by grouping and ordering the 1st new table it copies only unique records into 2nd table.

07-15-2008, 09:41 AM	#1 (permalink)
herpfan Registered User Join Date: Dec 2005 Posts: 18 OS: Win2000	deleting duplicate records Hopefully this is the right forum. I have very limited programming skills. Problem: Have a Visual FoxPro table with records > 235,000. I need to delete duplicate records based on 2 fields: If the ID field has more than 1 entry from the same OP then delete duplicates; entries from different OPs to the same ID field are OK. Any information is appreciated.

07-19-2008, 01:55 PM	#2 (permalink)
herpfan Registered User Join Date: Dec 2005 Posts: 18 OS: Win2000	Re: deleting duplicate records 46 views, no answer. a programmer at work showed me how. Here's the code he used if any are interested: select , upper(allt(op)) + '_' + upper(allt(id)) as op_id from "m:\inst\track.dbf" into table "m:\inst\New_1.dbf" select from new_1 group by op_id order by op_id into table "m:\inst\new_2.dbf"

07-20-2008, 12:59 PM	#3 (permalink)
jamiemac2005 TSF Enthusiast Join Date: Jul 2007 Location: Northampton, UK Posts: 820 OS: Win Vista Home Premium & Ubuntu Hardy(8.04)	Re: deleting duplicate records Sorry for the lack of replys, i would have replied but i have no experience of foxpro nor am i an amazing database coder and can only just work out what's going on from your solution. Thanks for posting the solution =] Cheers, Jamey __________________ If i refuse you help because of forum rules don't have a go at me, i quite like this forum and do not wish to get kicked off it. However, if i refuse you help because of some moral issue feel free. Jamey

07-20-2008, 03:49 PM	#4 (permalink)
herpfan Registered User Join Date: Dec 2005 Posts: 18 OS: Win2000	Re: deleting duplicate records no apology needed. have seen a few similar requests in asst forums. had a general idea of the logic but not how to do it. His code creates 2 new tables instead of deleting records. 2nd line of code works (I think) by grouping and ordering the 1st new table it copies only unique records into 2nd table.