var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: trigger doesnt work on view?
have maybe easy problem, but cannot get over it. I have view, and i have create a test trigger on it :
CREATE TRIGGER [PERSONAL_PERSONAL_UPDATE] ON [dbo].[PERSONAL_PERSONAL]
INSTEAD OF UPDATE
insert into test values ('s')
its just for testing
but when update anything in PERSONAL_PERSONAL , change is normally saved and no 's' is inserted into test... it seems to me that trigger is not fired?
I have tryed to change data in Enterprise manager and aswell through my aplication
any hits what am i doing wrong?
Re: trigger doesnt work on view?
Add the WITH VIEW_METADATA clause in your view definition. I was surprised to see myself that you need it to force an INSTEAD OF trigger to fire.
CREATE VIEW PERSONAL_PERSONAL