Hi Jean-Christoph, thanks a lot. I got a problem too:
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 Is there another problem? 2011/1/3 Jean-Christophe Deschamps <[email protected]> > > >/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 > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
