On 2 Jan 2011, at 1:23pm, Stephan Hüls wrote: > Hi Simon, thanks a lot this is working its not working at run time with qdbc > (sqlite3 console). The trigger should insert in genre_custom when a genre is > synced to genre_library. When this genre is contained in table > podcasts_custom the type from this table should be written to type of > genre_custom.
I don't think that that is what your SELECT does. Try it on a separate statement instead of a TRIGGER. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
