Recordset DTC and ERR object

Results 1 to 2 of 2

Thread: Recordset DTC and ERR object

  1. #1
    bo Guest

    Default Recordset DTC and ERR object

    How do I capture the Error when I use Recordset DTC? Normally, before executing the SQL statement, we would have a "on error resume next" statement. <BR><BR>In this case the commands are inside the Recordset Design Time Control. If I press a button to "UpdateRecord()" and there&#039s an error, how would I capture that?<BR><BR>Thanx for your attention!!!

  2. #2
    Join Date
    Dec 1969

    Default RE: Recordset DTC and ERR object

    Have look on this code to capture the error number,description<BR><BR>&#060;% On error resume next<BR>If err.number&#062;0 then%&#062;<BR> &#060;p&#062;&#060;font face="Arial, Helvetica, sans-serif" size="3"&#062;<BR><BR> &#060;%<BR> <BR> response.write "Error Number=" & err.number & "&#060;P&#062;"<BR> response.write "Error Descr.=" & err.description & "&#060;P&#062;"<BR> <BR> %&#062;<BR> <BR>contact at <BR> <BR> <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