HiI'm facing with this error on FB 2.5.8(latest stable version)/ W10 x64: Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements.Integer overflow. The result of an integer operation caused the most significant bit of the result to carry. on this query SELECT b.cant* IIF(b.PR_EAT_T<>0, b.PR_EAT_T-b.PR_EAT_T* b.P_TV_E /(100+b.P_TV_E), b.PR_I) FROM GS_FIED a INNER JOIN GS_FIEP b on a.id=b.id_doc cant NUMERIC(15,4) PR_EAT_T NUMERIC(16,4) P_TV_E NUMERIC (9,2) PR_I NUMERIC(16,4)
I have 2 records with same values: cant =5993.3160 PR_EAT_T=0.0000 P_TV_E=0.00 PR_I= 1580.3472 thanks