The ObjectContext.SetComplete Method

Introduction

The ObjectContext.SetComplete method can be used to declare that the transaction has been successfully completed. If the event OnTransactionCommit 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 retrieves all data from the table.

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"

            set rs = conn.execute(sql)

            If rs.BOF Or rs.EOF Then

                        ObjectContext.SetAbort

                        Response.Write "No data found"

            Else

                        ObjectContext.SetComplete

                        Response.Write "Data was found"

            end if

%>

Output