I have this query:

select
  id,
  importo,
  pagato
from
  elenco_scadenze
where
  (importo - pagato) <> 0.00

and this results:

ID    IMPORTO    PAGATO

29      60,0016       60,00

90    569,8344    569,83


If I do this:

UPDATE

  ELENCO_SCADENZE

set

  IMPORTO = CAST(IMPORTO AS DECIMAL(18,2))


the result of the query changes but is a mistake because the result must be _no rows_ :

ID    IMPORTO    PAGATO

29      60,00           60,00

90    569,83        569,83


Why?

Thanks.

--

Luigi Siciliano
--------------------------

  • [firebird-supp... Luigi Siciliano luigi...@tiscalinet.it [firebird-support]
    • Re: [fire... liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
      • Re: [... Luigi Siciliano luigi...@tiscalinet.it [firebird-support]
        • R... Svein Erling Tysvær setys...@gmail.com [firebird-support]
          • ... Luigi Siciliano luigi...@tiscalinet.it [firebird-support]

Reply via email to