On 2019-12-08 19:57, Simonov Denis via Firebird-devel wrote:
SQL> SET BIND OF DECFLOAT(16) TO CHAR;
SQL>
SQL> select
CON> NORMALIZE_DECFLOAT(4300) as n1,
CON> QUANTIZE(2, 9.9) as n2,
CON> COMPARE_DECFLOAT(2, 2) as n3,
CON> TOTALORDER(1.0, 1) as n4
CON> from rdb$database;
N1 N2 N3 N4
======================= ======================= ======= =======
4.3E+3 2.0 0 -1
SQL>
This works in ISQL, but gives an error in IBExpert. There may be a
problem with the Legacy API (SQLDA).
No, that also works OK in flamerobin which is still using SQLDA. I.e.
sooner of all that's an issue with IBE.
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
