Hi Simon, I have seperated the statement. This is working:
hu-intel:/dev/shmem> /fs/sda0/opt/mm/bin/qdbc -dmme "select type from podcasts_c ustom where 'Abenteuer' in (SELECT podcast FROM podcasts_custom)" Rows: 75 Cols: 1 Names: +type+ 00000: |1| 00001: |1| 00002: |1| ...... The createing of the trigger in a easier form is not working: 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) VALUES(NEW.genre_id, NEW.genre); END" qdbc: unable to execute - near ";": syntax error Can you tell me the correct syntax for sqlite? 2011/1/2 Simon Slavin <[email protected]> > > 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 > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
