Hi Harish, Yes it is possible. Look below for solution.
create trigger if not exists <trig_name> after insert on <table_name> when new.A=<condition> begin update <table_name> B=new.A; end; There is nothing tricky or hard for inserting into another table, same things should go. VENKAT Bug the Bugs ________________________________ From: Harish CS <cshar...@gmail.com> To: sqlite-users@sqlite.org Sent: Mon, February 7, 2011 2:08:16 PM Subject: [sqlite] Trigger to filter out characters Table T has two varchar columns A and B. UI allows entering values into column A only. On insert/update of records, I need to take out the value of A, filter out anything other than '0' to '9', '*', '#', '+' 'p', 'w' characters and copy it to column B. Is it possible to write a trigger to achieve this? If yes please give me a sample. (Also, if column B is in another table, is it possible?) Thanks -Harish -- View this message in context: http://old.nabble.com/Trigger-to-filter-out-characters-tp30861522p30861522.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
