SELECT cast((5411.000455/0.20) as numeric(16,6)) as mount FROM
MON$ATTACHMENTS r
This particular query can be rewritten as
SELECT 5411.000455*cast(1/0.20 as integer) as mount FROM MON$ATTACHMENTS r
Though it will not work equally well with other numbers, at least not if
||
=
- Original Message -
From: Svein Erling Tysvær
To: 'firebird-support@yahoogroups.com'
Sent: Thursday, March 29, 2012 3:24 AM
Subject: RE: [firebird-support] Arithmetic overflow or division by zero has
occurred.
SELECT cast((5411.000455/0.20) as numeric(16,6)) as mount FROM