Use a sub-select.
Shilpa Sheoran wrote:
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]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
