Trigger works in EM but not in ADP MS 2007 "jacobusroos" <u47871[ at ]uwe> 11/28/2008 9:40:05 PM Hi, I found a problem for which I cannot find the root : In ADP when updating my view via normal view mode or Form mode it won't fire my trigger. In Enterprise Manager it works just fine with out problems. Does ADP UI (MS 2007) update its view and forms via update statement or is it done via other means ? My Aim is to keep an audit trail of all changes made on a table via user working on the UI in adp. But this approach leaves me banging head against keyboard. Best Regards J.Jacobus Roos

Re: Trigger works in EM but not in ADP MS 2007 "jacobusroos" <u47871[ at ]uwe> 11/28/2008 10:33:36 PM In SQL profiler I found that the update done on ADP UI inflicts the update directly against the table rather than the view. That explains why the view's trigger never gets triggerd. But then it begs the question , under which situation will the UI ADP actualy update against the VIEW and not the table ?

Re: Trigger works in EM but not in ADP MS 2007 a a r o n _ k e m p f <aaron_kempf[ at ]hotmail.com> 12/22/2008 6:44:55 AM I believe that when you update against a view, you're most likely going to be sending direct edit statements against the table (that you're editing) which is hopefully the same as the 'uniqueTable' property of that form. I've never looked at 'Instead of' triggers, but those are supposed to do what you're asking for, IMHO On Nov 28, 1:40 pm, "jacobusroos" <u47871[ at ]uwe> wrote: [Quoted Text] > Hi, > > I found a problem for which I cannot find the root : > > In ADP when updating my view via normal view mode or Form mode it won't fire > my trigger. > In Enterprise Manager it works just fine with out problems. > > Does ADP UI (MS 2007) update its view and forms via update statement or is it > done via other means ? > > My Aim is to keep an audit trail of all changes made on a table via user > working on the UI in adp. But this approach leaves me banging head against > keyboard. > > Best Regards > J.Jacobus Roos