|
Subject:
|
UPDATE trigger won't fire on CASE-only condition
|
|
Posted By:
|
_Katka_
|
Post Date:
|
11/14/2003 5:58:08 AM
|
Hi,this is really important to me.When I'm trying to make standart UPDATE via UPDATE TRIGGER like this:
update [table] set [column]=[value] where [index_column]=[index]
it's working,but I've made auto-updating batch which cumulates many updates on one table together,but it won't fire the trigger,it goes like this:
update [table]
set [column]=case
when [index_column] in([index]) then [value]
else [column]
end
an update essentially works (ofcourse) but trigger is not fire for single-row update neither for multi-row update for example:
update [table]
set [column]=case
when [index_column] in([index1]) then [value1]
when [index_column] in([index2]) then [value2]
else [column]
end
I hope you understand,I'll be glad to see your solutions to this,coz whole project is driven thru this core batch-generator and it disables any update-trigger possibilities.
thx
|
|
Reply By:
|
alyeng2000
|
Reply Date:
|
11/14/2003 10:59:29 PM
|
some questions
i am asking why you are using trigger to update, and what types of triggers you are using
Ahmed Ali
Software Developer
|
|
