Hi Venkat, Could you please show me how to write the condition (to filter out characters)?
Thanks, Harish venkat easwar wrote: > > 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 > > -- View this message in context: http://old.nabble.com/Trigger-to-filter-out-characters-tp30861522p30861878.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
