Re: [sqlite] Re: [2.8.x] Incrementing a column automatically with INSERT/UPDATE?

[Gilles Ganault]

Hello

At 15:28 04/08/2007 -0400, you wrote:
UPDATE mytable SET timestamp = old.timestamp + 1 WHERE rowid=new.rowid;

I'm sorry to bother you again, but I can't figure out how to write a 
trigger that will set a column to 1 when a user creates a new record :-/

I tried the following but neither works:

================
CREATE TRIGGER insert_mytable_timestamp INSERT ON mytable
BEGIN
        INSERT INTO mytable (timestamp) values (1);
END;


CREATE TRIGGER insert_mytable_timestamp INSERT ON mytable
BEGIN
        UPDATE mytable SET timestamp = 1 WHERE rowid=new.rowid;
END;
================

Thanks,


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------