Re: [SQL] Verify Execute

2008-06-24 Thread Andreas Joseph Krogh
On Tuesday 24 June 2008 17:18:22 Shavonne Marietta Wijesinghe wrote: > 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_P

[SQL] Verify Execute

2008-06-24 Thread 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_TEM