Subject | Arithmetic overflow or division by zero has occurred. |
---|---|
Author | Ismael L. Donis Garcia |
Post date | 2012-03-28T19:11:45Z |
FB 2.5.1 superclasic
SELECT cast((5411.000455/0.000020) as numeric(16,6)) as mount
FROM MON$ATTACHMENTS r
*** IBPP::SQLException ***
Context: Statement::Fetch
Message: isc_dsql_fetch failed.
SQL Message : -802
Arithmetic overflow or division by zero has occurred.
Engine Code : 335544321
Engine Message :
arithmetic exception, numeric overflow, or string truncation
numeric value is out of rang
As I can solve this problem without decreasing the number of decimal?
Best Regards
=========
|| ISMAEL ||
=========
[Non-text portions of this message have been removed]
SELECT cast((5411.000455/0.000020) as numeric(16,6)) as mount
FROM MON$ATTACHMENTS r
*** IBPP::SQLException ***
Context: Statement::Fetch
Message: isc_dsql_fetch failed.
SQL Message : -802
Arithmetic overflow or division by zero has occurred.
Engine Code : 335544321
Engine Message :
arithmetic exception, numeric overflow, or string truncation
numeric value is out of rang
As I can solve this problem without decreasing the number of decimal?
Best Regards
=========
|| ISMAEL ||
=========
[Non-text portions of this message have been removed]