Quote:
Originally Posted by ItalianUruguayan
Thanks a lot for this. If I wanted to keep the browser tile as the first one, how would I do it?
I have tried this, but it doesn't work:
Code:
CREATE TRIGGER Activity_KeepTileFirst_UPDATE
AFTER UPDATE ON Activity
FOR EACH ROW
WHEN ( new.Type = 'browser')
BEGIN
UPDATE Activity
SET Date = datetime(Date,'+1 month')
WHERE rowid = new.rowid;
END
|
You need to look at the Activity table and find the entry for the browser. The value in the "Type" column should be obvious. In this case, I think it is "Browser". And the case is important.