Josh Millstein wrote:
> On 9/9/08 11:46 AM, "Igor Tandetnik" <[EMAIL PROTECTED]> wrote:
>> Josh Millstein <[EMAIL PROTECTED]>
>> wrote:
>>> Is there anyway to perform a trim to everything that is entered into
>>> a table instead of trimming before I put data in?
>>
>> update mytable set myfield=trim(myfield);
>>
>
> Yeah, but can you do that automatically on each insert into the db. Trim
> the whitespace, that is?>
Yes. Simply do these updates in triggers. You will need to add two
triggers, one that executes after each insert, and one that executes
after each update.
create trigger mytab_in after insert on mytable
begin
update mytable
set myfield = trim(myfield)
where rowid = new.rowid;
end;
create trigger mytab_in after update of myfield on mytable
begin
update mytable
set myfield = trim(myfield)
where rowid = new.rowid;
end;
Now your application can insert untrimmed data, but the database will
only store trimmed data, and therefore you will only ever retrieve
trimmed data.
HTH
Dennis Cote
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
