SQLite Forum

Can DEFAULT be the only possible value?
Login
```
create trigger t_bi_creation_date before insert of creation_date on t
begin
 select raise(ABORT, 'Cannot set creation_date');
end;
```

ooops ... you cannot use OF in an INSERT trigger ...

```
create trigger t_bi_creation_date before insert on t when new.creation_date is not null
begin
  select raise(ABORT, 'Cannot set creation_date');
end;
```