RE: [sqlite] Change value on a trigger

[Peter Pistorius]

There is an entire section in the SQL language specification dedicated to triggers, if 
you need further help just come and ask.

http://www.sqlite.org/lang.html

Regards,
PeterP.


-----Original Message-----
From: António Vieira (DSI) [mailto:[EMAIL PROTECTED] 
Sent: Thursday, March 25, 2004 11:29 AM
To: '[EMAIL PROTECTED]'
Subject: [sqlite] Change value on a trigger

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.

 


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]