--- In ib-support@y..., "Paul Schmidt" <paul@t...> wrote:

> On 30 May 2002 at 3:44, csswa wrote:

> 'Calc = ' || '18' * .3048 * '3.14' the output variable is a VARCHAR

(20)

All I got from that was a conversion error :-)

I should clarify that IB is only dumber than a $5 calculator on
division. That's the only arithmetic function that is a hassle
because you then have to explicitly type every value involved. If
it's multiplication, addition, or subtraction then there is no
problem at all. (Ahem, please disregard my earlier announcement
regarding 'the sky is falling!').

I'm curious why division is a problem but multiplication is okay,
since both involve decimal manipulation.

Anyway, I will just have to burn into my brain that if I make any
calculation involving division I must CAST everything in the
calculation.

Regards,
Andrew Ferguson
-- When they yell "hoedown" Andrew hits the floor.