>hu-intel:/dev/shmem> /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 w >here NEW.genre in (SELECT podcast FROM podcasts_custom)))); END"
Oops, you also need one more closing parenthesis before the semicolumn. I didn't try but it now looks fine. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
