V4RB2 Calc-Error

[Claudius Sailer]

Hi,

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

Bye


Claudius

-- 
iMac CD 2GHz / MacOS X 10.4de / RB 2006r3/ Valentina 2.3
Homepage    http://www.ClaSai.de
iChat        ryhoruk
RealBasic ListBoxes: [ I feel the need...the need for speed!!! ]