Delete and Insert at same time

[phoenixaz]

This code seems to work, but is this fundamentally correct or is there a better way of doing both a delete and an insert to follow:

sql_1= "Delete From Table1 Where CustomerID = "&CustomerID&" and Productid = "&Productid&" "
    	   
sql_2 = "insert into Table1 (ProductID,CustomerID,NewDate) values(" &_ 
           
        "'" & NewProductID & "'," &_
        "'" & CustomerID & "'," &_  
        "'" & NewDate & "')" 

objConn.Execute(sql_1)
objConn.Execute(sql_2)

[gk53]

this code should work. I'm not sure what you trying to archive, and what is your table structure, but nothing wrong with that code

[phoenixaz]

My main concern is if it's ok to first DELETE (which is what I want) and then INSERT. I am basically making a substitute. Like I said, it works in trial but wasn't sure if there is a fundamentally better way of doing that.

Thanks for looking at that, I appreciate it.