Tuesday, June 24, 2008

[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

No comments: