> create trigger r1 after insert on foo begin
> update foo set date_create=current_timestamp where rowid=new.rowid;
> end;
> create trigger r2 after update on foo begin
> update foo set date_lch=current_timestamp where rowid=new.rowid;
> end;
>
> --
> D. Richard Hipp <[EMAIL PROTECTED]>
>
create trigger r2 after update on foo begin
update foo set date_lch=current_timestamp where rowid=new.rowid;
update foo set date_create=old.date_create where rowid=new.rowid;
-- so the user can't change it
end;
I believe that's what he's after.
Regards
