[sqlite] Change value on a trigger

[António Vieira (DSI)]

In sqlite it's possible to change the value inserted or updated inside a
trigger?
 
Something like this:
 
CREATE TABLE foo (a); 
BEFORE INSERT ON foo BEGIN
    NEW.a=1;    
END; 

Thanks.