----- Original Message -----
From: Ann Harrison
To: firebird-support@yahoogroups.com
Sent: Monday, July 11, 2011 12:26 PM
Subject: {Disarmed} Re: {Disarmed} Re: [firebird-support] How do I determine a percentage of a dollar amount?



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]




--
MailScanner Virus/Spam/Malware: PASS (GZ)

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