Hi, I want to create a trigger when db is running after detecting backup is
older then actual version.
Its working by createing new schema:
CREATE TRIGGER genre_custom_insert AFTER INSERT ON library_genres
BEGIN
INSERT INTO genre_custom(genre_id, genre, type)
VALUES(NEW.genre_id, NEW.genre, (select type from podcasts_custom where
NEW.genre in (SELECT podcast FROM podcasts_custom)));
END;
Next line is not working:
/fs/sda0/opt/mm/bin/qdbc -dmme "CREATE TRIGGER genre_custom_insert AFTER
INSERT ON library_genres INSERT INTO genre_custom(genre_id, genre, type)
VALUES(NEW.genre_id, NEW.genre, (select type from podcasts_custom where
NEW.genre in (SELECT podcast FROM podcasts_custom)))"
What is the problem? How can I generate a sql command from schema syntax is
there someting wrong with BEGIN and END?
Thanks,
Stephan
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
