OOPS.. a mistake.. find the corrected things below.
create trigger if not exists <trig_name> after insert on <table_name> when
new.A IN ('0','1','2','3','4','5','6','7','8','9','*','#','+','p','w')
beginupdate <table_name> set B=new.A;
end;
Missed set in my last mail. It would have given you a syntax error.
VENKAT
Bug the Bugs
________________________________
From: venkat easwar <hareas...@yahoo.com>
To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
Sent: Mon, February 7, 2011 4:41:19 PM
Subject: Re: [sqlite] Trigger to filter out characters
Well. I thought it should be an easy deal for you hence left that part. Now
giving the conditioned trigger assuming the following condition. I leave the
testing part to your concern.
>I need to take out the value of A, filter out
> anything other than '0' to '9', '*', '#', '+' 'p', 'w'
create trigger if not exists <trig_name> after insert on <table_name> when
new.A IN ('0','1','2','3','4','5','6','7','8','9','*','#','+','p','w')
beginupdate <table_name> B=new.A;
end;
Only if the values inside the braces are inserted it will be copied to column B.
VENKAT
Bug the Bugs
________________________________
From: Harish CS <cshar...@gmail.com>
To: sqlite-users@sqlite.org
Sent: Mon, February 7, 2011 2:59:50 PM
Subject: Re: [sqlite] Trigger to filter out characters
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
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
