The ObjectContext.SetAbort Method

Introduction

The ObjectContext.SetAbort method can be used to abort a transaction. Any made changes will be rolled back and if the event OnTransactionAbort is implemented then it will be executed. You have to add the @Transaction directive otherwise the method will not work. The following example connects to a SQL server and uses the WHERE statement to retrieve some specific data from the table. However the data does not exist, therefore it will execute the ObjectContext.Abort method.

Example

<% @Transaction = "Required" %>

<%

            Dim conn, connString

            set conn = Server.CreateObject("ADODB.Connection")

            connString = "Provider=SQLOLEDB;Data Source=localhost;Database=YOUR_DBASE;UID=YOUR_USER;Pwd=YOUR_PW"

            conn.Open connString

            Dim rs, sql

            sql = "Select * from YOUR_TABLE where YOUR_FIELD='xx'"

            set rs = conn.execute(sql)

            If rs.BOF Or rs.EOF Then

                        ObjectContext.SetAbort

                        Response.Write "No data found"

            end if

%>

Output