V4RB2 Calc-Error

[Ruslan Zasukhin]

On 8/12/06 10:11 PM, "Claudius Sailer" <Claudius at sailer-online.de> wrote:

Hi  Claudius, 

> I am using following SQl-Code
> 
> SELECT t1.BDatum, t2.Konto_Name, t3.Konto_Name, t4.Kategorie_Name,
> t1.Betrag, t1.Betrag / 100, t1.Kommentar
> FROM Buchungen t1, Konten t2, Konten t3, Kategorien t4
> WHERE t1.Herk_Konto=t2.RecID
> AND t1.Ziel_Konto=t3.RecID
> AND t1.Kategorie_ID=t4.RecID
> AND ( t4.Kategorie_Name='Reisen'
> )
> ORDER BY t1.BDatum ASC
> 
> 
> t1.Betrag is integer. result of t1.Betrag is always
> 
> Betrag  Betrag/100
> 1234  12,00
> 2345  23,00
> 
> this is wrong. Should I make MantisCall

You expect to get 

 Betrag        Betrag/100
 1234        12,34
 2345        23,35

?

Please try t1.Betrag / 100.0



-- 
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]