Hi all,

I have built the following simple repro code of something that is driving me crazy:

create Cursor temp (unitPrice Y, quantity B(5), discount B(5))

insert into temp values (35760, 10, 28.221)

? UnitPrice                 * quantity * (1 - (discount/100))    && displays 256685.28
? cast(UnitPrice as double) * quantity * (1 - (discount/100))    && displays 256681.704

There is a difference of almost 4 between the 2 calculations. I have a lot of code that makes calculations, and if I have to CAST every bit of it, it's going to take quite a time. Is there a simple solution to this? Is this a BUG or a FEATURE?

Thanks a lot,
Javier.