No because the record has 6 decimal and can bring a value that is not zeros

For example:

SELECT cast(((163303.39/49.215486) * 89.218715) as decimal(15,2)) as val from MON$DATABASE

I have it in a procedure stored as follows:
dec_cvmn = cast(((:dec_vmn/:dec_einv) * :dec_cant) as decimal(15,2));

Best Regards
=========
|| ISMAEL ||
=========

----- Original Message -----
From: Anderson Farias
To: firebird-support@yahoogroups.com
Sent: Tuesday, March 01, 2011 2:17 PM
Subject: Re: [firebird-support] Err Number 335544779



Hi,

| When executing the following sentence you give me error.
|SELECT cast(((163303.39/49.210000) * 49.210000) as decimal(15,2)) as val
|from MON$DATABASE

One way is *not* to use that many decimal places, like:

SELECT cast(((163303.39/49.210000) * 49.21) as decimal(15,2)) as val
from MON$DATABASE

Regards,
Anderson





[Non-text portions of this message have been removed]