Hello , Is it possible to simplify the code? I have ten fields to UPDATE. (STATUS, Responsavel, Country,......)
Thanks, Ernany ********************************************************************************************************************** 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 UPDATE Bens SET *Responsavel *= CASE (SELECT COUNT(BENSBK.Responsavel) FROM BENSBK WHERE BENSBK.BEM = Bens.BEM) WHEN 0 THEN Bens.Responsavel ELSE (SELECT BENSBK.Responsavel FROM BENSBK WHERE BENSBK.BEM = Bens.BEM) END UPDATE Bens SET *Country *= CASE (SELECT COUNT(BENSBK.Country ) FROM BENSBK WHERE BENSBK.BEM = Bens.BEM) WHEN 0 THEN Bens.Country ELSE (SELECT BENSBK.Country FROM BENSBK WHERE BENSBK.BEM = Bens.BEM) END ********************************************************************************************************************** _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users