Re: [firebird-support] strange bahaviour

[Luigi Siciliano luigi...@tiscalinet.it [firebird-support]]

Hallo,

Il 04/07/2019 11:21, Svein Erling Tysvær setys...@gmail.com 
[firebird-support] ha scritto:
If you were using dialect 1, I would say the difference would be 
expected (since NUMERIC(18) is equal to DOUBLE PRECISION in dialect 
1), but I guess you're using dialect 3?


Yes, I use dialect 3 on FB 2.5.8.27089

Luigi Siciliano

--

Re: [firebird-support] strange bahaviour

[Svein Erling Tysvær setys...@gmail.com [firebird-support]]

If you were using dialect 1, I would say the difference would be expected
(since NUMERIC(18) is equal to DOUBLE PRECISION in dialect 1), but I guess
you're using dialect 3?

What do you get if you run:

SELECT ID, IMPORTO - TRUNC(IMPORTO), PAGATO - TRUNC(PAGATO)
FROM ELENCO_SCADENZE

Is the problem the same after

UPDATE
  ELENCO_SCADENZE
SET
  IMPORTO = TRUNC(IMPORTO, 2)

HTH,
Set

ons. 3. jul. 2019 kl. 17:27 skrev Luigi Siciliano luigi...@tiscalinet.it
[firebird-support] :

>
>
> Hallo,
> Il 03/07/2019 16:35, liviuslivius liviusliv...@poczta.onet.pl
> [firebird-support] ha scritto:
>
>
> What are the exact types of both fields?
>
> NUMERIC(18,4) via domain:
>
> CREATE DOMAIN CURRENCY_D
>  AS Numeric(18,4)
>  DEFAULT 0.00
>  NOT NULL
> ;
> Thanks.
> --
>
> Luigi Siciliano
> --
>
>
>
> 

[firebird-support] Broken link in Firebird 4 source files

[valdir.mar...@ig.com.br [firebird-support]]

Hi.

I have noted a broken link in Firebird 4 source files:
https://github.com/FirebirdSQL/firebird/commit/2da0a6edc3d43947933936b4e684bc445c4445ac


The broken links is:
http://www.ibphoenix.com/main.nfs?a=ibphoenix=ibp_idpl

Thanks,
Valdir