Thread: void UPDATE function?
What is a good way to trigger an UPDATE of a row without actually changing anything? I have a trigger that will update the timestamp of a record, and in this case, want to trigger it because I am adding a related row in another table. UPDATE bugs WHERE pkey='3' Doesn't seem to work. -- Adam Haberlach |A cat spends her life conflicted between a adam@newsnipple.com |deep, passionate, and profound desire for http://www.newsnipple.com |fish and an equally deep, passionate, and '88 EX500 |profound desire to avoid getting wet.
Hi Adam, Would this work? UPDATE bugs SET somefield=somefield WHERE pkey='3'; i.e. set a field to itself. I don't know whether or not this would be optimised away - but it could be worth a try. Hope this helps. Francis Solomon > > What is a good way to trigger an UPDATE of a row > without actually > changing anything? I have a trigger that will update the timestamp > of a record, and in this case, want to trigger it because I am > adding a related row in another table. > > UPDATE bugs WHERE pkey='3' > > Doesn't seem to work.