On Mon, Jul 11, 2011 at 1:04 PM, SoftTech <miket@...> wrote:

> Thank you Marcin for the reply.
>
> Input variable V_SETTLEMENT_PERCENTAGE is defined as a SmallInt
>
> ...
>
> It returns 0
>
>

OK. Decleare that variable as scaled numeric - whatever precision you
expect - or cast the reference in the divide operation. Firebird is
following the rules of the SQL Standard which are not necessarily intuitive.

Cheers,

Ann


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