Re: No trigger exception message

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Hansjörg,

I do so
----
....
....
RAISERROR ('Your Error Message ', 16, 1)
ROLLBACK TRANSACTION
....
----
the trigger messages are handled.
(Access2002 sp2, Msde2000 sp4)

Bye
Giorgio

"Hansjörg Zimmermann" <hjzimmermann@xxxxxxx> ha scritto nel messaggio
news:uAl6$5EsFHA.3796@xxxxxxxxxxxxxxxxxxxxxxx
> Hi, i have a problem with the handling of error messages produced by a
> trigger. I have defined a trigger which contains business logic and checks
> some rules before storing the data. In case of a error i use the
RAISERROR()
> command.
>
> When i use MS-Access on one PC to inserted records in the table the error
> message issued by the trigger appears, which is the expected result.
>
> On a other installation MS-Access does not show the message, it just says
> nothing and does not allow me to store the record. Because it does not
show
> the error message of the trigger, the user has no idea what the reason is.
>
> Does anyone know, which setting allows to specify how trigger messages are
> handled ?
>
> Thanks for your reply
>
>


.

Relevant Pages

  • Re: Trigger Problem, Please Help
    ... I haven't done any CE stuff, but those error messages look like they ... tried looking at the user and role security for your DB? ... > Yes all of the tables referenced exist, and the trigger works fine if I ... > Source:Microsoft Sql server 2000 Windows CE Edition ...
    (microsoft.public.sqlserver.programming)
  • No trigger exception message
    ... i have a problem with the handling of error messages produced by a ... I have defined a trigger which contains business logic and checks ... When i use MS-Access on one PC to inserted records in the table the error ... On a other installation MS-Access does not show the message, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: TEXT field in trigger; valid workaround?
    ... > The two things I want to ensure are: 1) The error messages ... data is uncommitted but the auxiliary table INSERT/SELECT runs in the same ... transaction as the trigger. ... > the core table (which I link via the primary key: ...
    (microsoft.public.sqlserver.programming)
  • Re: No trigger exception message
    ... Did you have the same problem and found a workaround? ... i have a problem with the handling of error messages produced by a ... >> trigger. ... >> When i use MS-Access on one PC to inserted records in the table the error ...
    (microsoft.public.access.adp.sqlserver)
  • Re: No trigger exception message
    ... i have a problem with the handling of error messages produced by a ... I have defined a trigger which contains business logic and checks ... > When i use MS-Access on one PC to inserted records in the table the error ... > On a other installation MS-Access does not show the message, ...
    (microsoft.public.access.adp.sqlserver)