Stephan Hüls <[email protected]> wrote: > 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?
There's nothing wrong *with* BEGIN and END. But there's something wrong *without* them. They are required by CREATE TRIGGER syntax, but your second statement lacks them. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
