Re: [sqlite] DROP TRIGGER-Statement within a Trigger

On Fri, 2 Oct 2009 12:18:11 +0200, Michael Werber wrote: >KN> The need to change a schema on the fly is usually caused by >KN> bad design. What is the probvlem you try to resolve? > > the problem is i have a table that should contain only the > last xxx inserts. > > to do so i created a trigger:

Re: [sqlite] DROP TRIGGER-Statement within a Trigger

KN> The need to change a schema on the fly is usually caused by KN> bad design. What is the probvlem you try to resolve? the problem is i have a table that should contain only the last xxx inserts. to do so i created a trigger: CREATE TRIGGER trg_TrimMessdataLast AFTER INSERT ON MessdataAl

Re: [sqlite] DROP TRIGGER-Statement within a Trigger

On Fri, 2 Oct 2009 10:43:38 +0200, Michael Werber wrote: >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 >B

[sqlite] DROP TRIGGER-Statement within a Trigger

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 TR