V4RB2 Calc-Error

[Ruslan Zasukhin]

On 8/13/06 1:15 PM, "Claudius Sailer" <Claudius at sailer-online.de> wrote:

Hi Claudius 

>> You expect to get
>> 
>>  Betrag        Betrag/100
>>  1234        12,34
>>  2345        23,35
>> 
>> ?
> 
> Yes
> 
> 
>> Please try t1.Betrag / 100.0
> 
> this works, but this couldn't be solution.
> The SQL is written by user.
> I have a modul in my application where they can click together SQL-
> Statements and calculation fields. They would expect that /100 works
> correct.

Disputable.

We use C-style.

In first case you have
        INT / INT = INT

In second case you have

        INT / DOUBLE = DOUBLE

I think  that e.g. MySQL have similar rules for expressions.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]