Hello, I have two sqlite databases. (db1, db2) I try to write a trigger in db1 which inserts data to a table in db2. In the sqlite docu there is a section about "Temp Triggers". "...Except, it is possible to create a TEMP TRIGGER on a table in another database."
CREATE TEMP TRIGGER ex1 AFTER INSERT ON main.tab1 BEGIN ... I tried this but I get always the error SQL Error: qualified table names are not allowed on INSERT, UPDATE, and DELETE statements within triggers If this is not allowed within a trigger, is there a workournd to synchronize two tables between different databases? regards _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
