Professional Web Applications Themes

Custom Unique Key Error Message - Microsoft SQL / MS SQL Server

Dear Concerned, When I hit the DB with a Query and if it encounters to be an Unique Key violation, then I need to format the message into a Custom Message stating which Column of the Insert Query is been violated. I mean instead of showing the DB Error something like.. "Violation of UNIQUE KEY constraint 'EmployeeMast_UK1'. Cannot insert duplicate key in object 'EmployeeMast'. The statement has been terminated." I want to build a Custom Error Message with the Column Name which is violating the Unique Key of the Table. Any help on this would be appreciated. Thanx, Srinivas.K...

  1. #1

    Default Custom Unique Key Error Message

    Dear Concerned,

    When I hit the DB with a Query and if it
    encounters to be an Unique Key violation, then I need to
    format the message into a Custom Message stating which
    Column of the Insert Query is been violated. I mean
    instead of showing the DB Error something like..

    "Violation of UNIQUE KEY constraint 'EmployeeMast_UK1'.
    Cannot insert duplicate key in object 'EmployeeMast'.
    The statement has been terminated."

    I want to build a Custom Error Message with the Column
    Name which is violating the Unique Key of the Table.

    Any help on this would be appreciated.

    Thanx,
    Srinivas.K

    Srinivas Guest

  2. #2

    Default Custom Unique Key Error Message

    If your application is for Internet use, I would not
    reccomend giving any table, constraint, etc. information
    in your custom error. (security)

    Ray Higdon MCSE, MCDBA, CCNA
     
    Ray Guest

  3. #3

    Default Re: Custom Unique Key Error Message

    Dear Itzik Ben-Gan,

    Well thanx man, it really worked out.

    Best Regards,
    Srinivas.K
     
    would not cost you 
    and parsing it at the 
    desired 
    system error, you can 
    the constraint 
    this would cost you 
    >
    >
    >.
    >[/ref]
    Srinivas Guest

Similar Threads

  1. How To Supress Acrobat Error Message And Alert Message
    By ckpang@adobeforums.com in forum Adobe Acrobat SDK
    Replies: 10
    Last Post: January 15th, 11:33 AM
  2. Error Message: FindControl requires that controls have unique IDs.
    By SouthSpawn in forum ASP.NET Data Grid Control
    Replies: 1
    Last Post: April 21st, 08:35 PM
  3. How to return a custom defined soap error message
    By Mullin Yu in forum ASP.NET Web Services
    Replies: 1
    Last Post: January 20th, 11:33 AM
  4. Custom error message in custom Web publishing
    By Tim Booth in forum FileMaker
    Replies: 0
    Last Post: July 2nd, 05:35 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139