RE: [NF] Trigger question

Mike, You are correct in your assumption and you DO need to add the where clause.

Dave

-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of mbsoftwaresolutions@mbsoftwaresolutions.com Sent: 16 August 2017 04:07 To: ProFox profox@leafe.com Subject: [NF] Trigger question

MariaDB backend (but could be SQL Server too)

Given this trigger: UPDATE MyTable SET cItemID = new.cID WHERE cItemID = old.cID

My question: will this trigger fire even if the old.cID = new.cID? Or do I need to add to the WHERE clause something like "....and old.cID <> new.cID"

???

tia, --Mike

[excessive quoting removed by server]