Professional Web Applications Themes

RAISEERROR from within constraint? - Microsoft SQL / MS SQL Server

It appears that RAISEERROR cannot be called from a constraint? If this is the case, how can I display a custom message when validation fails? I know I can do it with a trigger, but in my case it will be much harder to do with a trigger. It seems an unnecesary restriction that I cannot call RAISEERROR from a contraint, in fact it seems to me that would be the most appropiate place to call RAISEERROR so the user can see a customized message when a constraint fails. Thanks, Zig Mandel...

  1. #1

    Default RAISEERROR from within constraint?

    It appears that RAISEERROR cannot be called from a constraint?
    If this is the case, how can I display a custom message when validation
    fails?
    I know I can do it with a trigger, but in my case it will be much harder to
    do with a trigger.

    It seems an unnecesary restriction that I cannot call RAISEERROR from a
    contraint, in fact it seems to me that would be the most appropiate place to
    call RAISEERROR so the user can see a customized message when a constraint
    fails.

    Thanks,

    Zig Mandel


    Zig Mandel Guest

  2. #2

    Default Re: RAISEERROR from within constraint?

    Zig,

    I'm afraid that I'm just posting to confirm your observations. This is one of the upside with
    triggers. I prefer aiming at catching errors in the client and not have the SQL error "shine
    through".

    --
    Tibor Karaszi, SQL Server MVP
    Archive at: [url]http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver[/url]


    "Zig Mandel" <z_man_del[remove underscores and this]mac.com> wrote in message
    news:OHVnGzpRDHA.2240TK2MSFTNGP11.phx.gbl...
    > It appears that RAISEERROR cannot be called from a constraint?
    > If this is the case, how can I display a custom message when validation
    > fails?
    > I know I can do it with a trigger, but in my case it will be much harder to
    > do with a trigger.
    >
    > It seems an unnecesary restriction that I cannot call RAISEERROR from a
    > contraint, in fact it seems to me that would be the most appropiate place to
    > call RAISEERROR so the user can see a customized message when a constraint
    > fails.
    >
    > Thanks,
    >
    > Zig Mandel
    >
    >

    Tibor Karaszi Guest

Similar Threads

  1. Doc.submitForm: RaiseError, File open failed
    By Jean-Philippe_Pouliot@adobeforums.com in forum Adobe Acrobat Windows
    Replies: 0
    Last Post: April 22nd, 08:54 PM
  2. #26312 [Opn->Bgs]: bug in raiseError in DB/common.php
    By iliaa@php.net in forum PHP Development
    Replies: 0
    Last Post: November 19th, 02:45 PM
  3. #26312 [NEW]: bug in raiseError in DB/common.php
    By wilfrid at digifactory dot fr in forum PHP Development
    Replies: 0
    Last Post: November 19th, 10:39 AM
  4. Best way to create this constraint?
    By Zig Mandel in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 1st, 12:52 PM
  5. Conditional Constraint?
    By Howard J. Rogers in forum Oracle Server
    Replies: 9
    Last Post: December 24th, 02:52 PM

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