[SQL] Verify Execute

[Shavonne Marietta Wijesinghe]

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