>/fs/sda0/opt/mm/bin/qdbc -dmme "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"
^
|
You need a semicolumn before END -------------------------'
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
