Forum Discussion

sankar_k's avatar
sankar_k
Occasional Contributor
11 years ago

Checking success of DB transaction

Hi There I am trying to insert a record into Microsoft SQL Server database table using ADO objects. The sample code is as follows Dim AConnection    Set AConnection = ADO.CreateADOCon...
  • karkadil's avatar
    karkadil
    11 years ago
    If it is not successful, you'll get an exception and script execution will stop. Sp you will definitely know it was not successful :)
sankar_k's avatar
sankar_k
Occasional Contributor
11 years ago
Thanks for the quick response.  I check the connection using the sytax



If AConnection.Connected then

-----



Else

Log.Error ("Connection Faile")

End If



Will I be able to do something similar in these lines