Damon From the R:> EDIT ALL IN tablename WHERE job = 'BE9124' AND EID = '9137' Click on one of the rows and then press F9. Answer yes and the row is gone. The other thing you can do is from the R:> DEL DUP FROM tablename this will delete all duplicate rows from the table. Buddy
________________________________ From: [email protected] on behalf of Gray, Damon Sent: Thu 11/20/2008 6:12 PM To: RBASE-L Mailing List 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
