Venkat,
Thanks.
But this is not filtering characters.
For example, if user enters '12ab34', it should remove 'ab' and enter
'1234'.
Thanks,
Harish
venkat easwar wrote:
>
> 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 <[email protected]>
> To: [email protected]
> 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 <[email protected]>
>> To: [email protected]
>> 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
>> [email protected]
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>>
>>
>>
>> _______________________________________________
>> sqlite-users mailing list
>> [email protected]
>> 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
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
>
>
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
--
View this message in context:
http://old.nabble.com/Trigger-to-filter-out-characters-tp30861522p30863148.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
