Re: [sqlite] Detecting the change from inside a trigger

Vladimir Stokic wrote: Hi there, Is there any way to identify the change that occurred on a table from within a trigger defined on that table? The solution that I can think of is to create an SQL statement by using new.Column1 or old.Column1, but I was wondering if it can be done faster, by using

[sqlite] Detecting the change from inside a trigger

Hi there, Is there any way to identify the change that occurred on a table from within a trigger defined on that table? The solution that I can think of is to create an SQL statement by using new.Column1 or old.Column1, but I was wondering if it can be done faster, by using, say, a user defined fu