Transactions in DB

Results 1 to 2 of 2

Thread: Transactions in DB

  1. #1
    Shreekanth Nadig Guest

    Default Transactions in DB

    Hello<BR><BR>When I try to use Transaction in SQL Server in the following manner(shown below), I&#039m not able to trap errors,...particularly using Err.number property. Please let me know whats wrong here or let me know of any other method<BR>Thanx in advance.<BR><BR>ConnectionObject.BeginTrans()<BR> -------<BR> ------- <BR><BR> If Err.number Then<BR> Response.Write "Error!" & Err.description<BR> ConnectionObject.RollbackTrans<BR> <BR> Else<BR> ConnectionObject.CommitTrans<BR> Response.Write "Transaction complete"<BR> End If

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default RE: Transactions in DB

    How about trying <BR><BR>If Err.number &#060;&#062; 0 Then<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts