Trigger works in EM but not in ADP MS 2007

[jacobusroos]

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

 

[jacobusroos]

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 ?

 

[a a r o n _ k e m p f]

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