hallo Sqlite-users,
i want to update a trigger from within another trigger. because there is no
update-trigger statement i tried to drop and recreate my trigger. i
tried this:
CREATE TRIGGER trg_update AFTER UPDATE ON SystemData
BEGIN
DROP TRIGGER trg_TrimMessdataLast;
-- CREATE TRIGGER trg_TrimMessdataLast Statement omitted, it will follow
here
END;
but i get: "near ´DROP´: syntax error"
so the question is am i doing something wrong or is it impossible to
drop a trigger from within a trigger?
thank you
michael werber
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
