Make sure to SET EQNULL ON Before doing the Delete Duplicates thing. That way, NULLs will match and all the true duplicates will go. If you have an autonumber column, then that will interfere. In that case, DEL DUP FROM Tablename USING columnlist will let you specify all but the Autonum column so the command will do what you want.
Dennis McGrath ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of TOM HART Sent: Thursday, November 20, 2008 5:29 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: delete rows Try del dup from 'yourtablename' ________________________________ From: "Gray, Damon" <[EMAIL PROTECTED]> To: RBASE-L Mailing List <[email protected]> Sent: Thursday, November 20, 2008 5:12:27 PM Subject: [RBASE-L] - delete rows I apologize for the extreme ignorance that shows up in my questions, but I am still on a steep learning curve with this tool. I have a couple of rows in a table that are identical in every respect. It is a double entry, and one of them needs to go away, but I don’t see anything that uniquely identifies one row from the other. There has to be, but I cannot see it. Is there a hidden primary key somewhere? I can’t do a delete from laborbilled where job = ‘BE9124’ and EID = ‘9137’ because that will delete both rows. Does my question even make sense? Damon J. Gray Anvil Corporation Business Services (360) 937-0770
