Hi Jean-Christophe, I tried it there is a problem, is there a ( missin?
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" qdbc: unable to execute - near ")": syntax error 2011/1/3 Jean-Christophe Deschamps <[email protected]> > > >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 > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
