Delete a row

i am using this to delete all rows with a certain name

VB Code:

con.Execute "DELETE FROM Tdetails WHERE Name = 'Trade'"

what do you do to delete only one row ?

thanks.

Quote:

---

Originally Posted by user name

i am using this to delete all rows with a certain name

VB Code:

con.Execute "DELETE FROM Tdetails WHERE Name = 'Trade'"

what do you do to delete only one row ?

thanks.

---

VB Code:

WHERE Name = 'Trade'"  and otherData = 'True'

thanks for that but the other fields are the same aswell. is there a way of deleting something knowing the row number ?

thanks.