Gilles Ganault <gilles.ganault-jG/[EMAIL PROTECTED]>
wrote:
So, I guess the solution is to write a trigger. Problem is, I've
never used
triggers before, so I don't really know how to get around to fetching
the
previous value of a timestamp column and increment it whenever a
record is
updated:
CREATE TRIGGER update_timestamp UPDATE ON mytable
BEGIN
UPDATE mytable SET timestamp = old.timestamp + 1;
END;
UPDATE mytable SET timestamp = old.timestamp + 1
WHERE rowid=new.rowid;
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
