trapping datatabase errors

Results 1 to 2 of 2

Thread: trapping datatabase errors

  1. #1
    Join Date
    Dec 1969

    Default trapping datatabase errors

    How does one trap database errors like duplicate record insertion?I tried using if err.number>0 test but the sql execution statement is where the execution stops...Any help would be highly appreciated.

  2. #2
    Join Date
    Dec 1969

    Default Trap before insert

    Check the table for that record if record set count is 0 then it's not a duplicate

Posting Permissions

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