Re: [sqlite] UPDATE - to simplify the code...

"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) >> W

Re: [sqlite] UPDATE - to simplify the code...

Hello Igor, > 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 BENSB

Re: [sqlite] UPDATE - to simplify the code...

"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 T

[sqlite] UPDATE - to simplify the code...

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(B