Re: No trigger exception message

Hi Giorgio

I now, that this works in general. I develop my software on two machines
(Desktop and Notebook).
On one machine i get the message, on the other not. Both have Windows XP
SP2, and A2003 SP1.

"giorgio rancati" <giorgio_No_Spalmer_rancati@xxxxxxxxxx> schrieb im
Newsbeitrag news:OIT3NmesFHA.3424@xxxxxxxxxxxxxxxxxxxxxxx
> 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)
  • Re: No trigger exception message
    ... Bye Giorgio ... 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 ...
    (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)
  • 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
    ... 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)