Re: No trigger exception message

Tech-Archive recommends: Fix windows errors by optimizing your registry

Have both pc the same MDAC version ?

Bye Giorgio


"Hansjörg Zimmermann" <hjzimmermann@xxxxxxx> ha scritto nel messaggio
news:OUw0stksFHA.1172@xxxxxxxxxxxxxxxxxxxxxxx
> 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: No trigger exception message
    ... > Hi 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: 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)
  • 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)
  • 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)