If record exists

In vb5, I have code that works fine to delete a record if the name is "Brown"

sName = Brown
Set dbtemp = OpenDatabase(dbname)
    dbtemp.Execute "DELETE * FROM List1 WHERE Name = " & "'"  &  sName & "'"
dbtemp.Close

Do I need a trap in case there are is no Brown in the Name field.
faybAsked:
Who is Participating?
 
robbertConnect With a Mentor Commented:
No. If there is no sName in the database, the DELETE statement will not have any effect.
0
All Courses

From novice to tech pro — start learning today.