"Ernany" <[EMAIL PROTECTED]> wrote in
message news:[EMAIL PROTECTED]
> Is it possible to simplify the code? I have ten fields to UPDATE.
> (STATUS, Responsavel, Country,......)
>
> UPDATE Bens SET *STATUS *=
> CASE (SELECT COUNT(BENSBK.STATUS) FROM BENSBK WHERE BENSBK.BEM =
> Bens.BEM)
> WHEN 0 THEN Bens.STATUS
> ELSE (SELECT BENSBK.STATUS FROM BENSBK WHERE BENSBK.BEM = Bens.BEM)
> END
[similar statements snipped]
Try this:
update Bens
set STATUS=coalesce(
(SELECT BENSBK.STATUS FROM BENSBK WHERE BENSBK.BEM = Bens.BEM),
STATUS),
set Responsavel=coalesce(
(SELECT BENSBK.Responsavel FROM BENSBK WHERE BENSBK.BEM = Bens.BEM),
Responsavel),
set Country=coalesce(
(SELECT BENSBK.Country FROM BENSBK WHERE BENSBK.BEM = Bens.BEM),
Country);
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
