Re: No trigger exception message

Thanks for your hint. Since this is a known bug since january 2005 i am
supprised that there is still no patch from microsoft. Even no workaround
is mentioned.
Did you have the same problem and found a workaround ?


"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
schrieb im Newsbeitrag news:eKZNIFFsFHA.1252@xxxxxxxxxxxxxxxxxxxxxxx
> This is a known problem with A2002:
> http://support.microsoft.com/default.aspx?scid=kb;EN-US;275057
>
> --
> Sylvain Lafontaine, ing.
> MVP - Technologies Virtual-PC
>
>
> "Hansjörg Zimmermann" <hjzimmermann@xxxxxxx> wrote in message
> 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: No trigger exception message
    ... I develop my software on two machines ... > the trigger messages are handled. ... i have a problem with the handling of error messages produced by a ... >> When i use MS-Access on one PC to inserted records in the table the error ...
    (microsoft.public.access.adp.sqlserver)
  • 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: No trigger exception message
    ... the trigger messages are handled. ... i have a problem with the handling of error messages produced by a ... > 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: 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)
  • 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)
Loading