[SQL] Verify Execute

Hello

 

Is there a way to find out if the EXECUTE of a UPDATE, INSERT has been completed successfully?

 

Here is an example of what I do:

 

Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Form_Store_PSQL"

 

Set oRs = Server.CreateObject("ADODB.Recordset" )

strSQL = "INSERT INTO TABLE_TEMP (ID) VALUES ('1')"

conn.Execute strSQL

 

Thank you

 

Shavonne Wijesinghe