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

Reply via email to