Bill You can't use a where clause with del dup. As others suggested you would have to project originalTable to another temptable.
As always before trying this make sure you have a good backup of the database or table. R:>PROJ myTempTable FROM originalTable USI ALL WHE Compdate IS NULL R:>DEL DUP FROM myTempTable USI reqdate, section, range, plot R:>DEL ROWS FROM originalTable WHE CompDate IS NULL R:>APP myTempTable TO originalTable Buddy -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of William Owens Sent: Friday, April 01, 2005 11:21 AM To: RBG7-L Mailing List Subject: [RBG7-L] - FW: [RBG7-L] - RE: delete rows Buddy I was thinking along the same line but I only want to delete the row where compdate fails Can I use your sample with a where clause....where compdate fails? Bill -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Walker, Buddy Sent: Friday, April 01, 2005 10:51 AM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: delete rows Bill Can't remember if this worked in 6.1 or not. DEL DUP FROM tableName USING reqdate,section,range,plot,compdate Buddy -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of William Owens Sent: Friday, April 01, 2005 10:33 AM To: RBG7-L Mailing List Subject: [RBG7-L] - delete rows I have a table that can have duplicate rows (Dos 6.1) Is there a way I can delete dup rows based on certain fields? example 5 fields > reqdate, section, range, plot, compdate I want to delete the row where reqdate,section,range,plot are equal and compdate fails? Thanks Bill
