Does SQLite support declaring/using local variables in a Trigger? If not what is the alternative?
CREATE TRIGGER trig1 AFTER INSERT ON table1 BEGIN DECLARE num INTEGER; SELECT COUNT(id) INTO num FROM table1; INSERT INTO table2 (count) VALUES (num); END; Thanks Shilpa ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
