« Return to Thread: Multiple WHENs in triggers

Re: Multiple WHENs in triggers

by Igor Tandetnik :: Rate this Message:

On 2/28/2012 11:05 AM, Pavel Ivanov wrote:

> Or you can also do it like this:
>
> CREATE TRIGGER UpdateSaleItemDescription AFTER INSERT ON SaleItem
> BEGIN
> UPDATE SaleItem SET SaleItem_Description='This is seven' WHERE
> SaleItem_ID=NEW.SaleItem_Id
> AND NEW.SaleItem_ID='7';
> UPDATE SaleItem SET SaleItem_Description='This is not seven' WHERE
> SaleItem_ID=NEW.SaleItem_Id
> AND NEW.SaleItem_ID<>'7';
> END;
>

Or like this:

UPDATE SaleItem SET SaleItem_Description=
(case when NEW.SaleItem_ID='7' then 'This is seven' else 'This is not
seven' end)
WHERE SaleItem_ID=NEW.SaleItem_Id;

--
Igor Tandetnik

_______________________________________________
sqlite-users mailing list
sqlite-users@...
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

« Return to Thread: Multiple WHENs in triggers