Engin Guelen wrote: > The Following View and Trigger Code compiles w/o Errors.
Instead of the DELETE, you could use "SELECT RAISE(FAIL, 'triggered');". > But when changing the SYNC column nothing happens to REF_TAB, that means the > trigger does not fire. With the following: CREATE TABLE env_tab(schema,tab,altered,env); INSERT INTO "env_tab" VALUES(1,1,1,1); CREATE TABLE ref_tab(schema,tab,created); INSERT INTO "ref_tab" VALUES(1,1,1); CREATE TABLE X_DEV2SIT_TAB(tab); INSERT INTO "X_DEV2SIT_TAB" VALUES(1); CREATE TABLE env_col(tv,schema,tab,pf,u,col,nn,inc,cache,type,length,scale); INSERT INTO "env_col" VALUES(1,1,1,1,1,1,1,1,1,1,1,1); CREATE TABLE ref_col(tv,schema,tab,pf,u,col,nn,inc,cache,type,length,scale); INSERT INTO "ref_col" VALUES(1,1,1,1,1,1,1,1,1,1,1,1); it works for me. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
