V4RB: problem with dates

[Claudius Sailer]

Hi,

I have a little CodeGenerator (User can click a report together, also 
with restrictions) which buolds following Code


SELECT t1.BDatum, t2.Konto_Name, t3.Konto_Name, t4.Kategorie_Name, 
t1.Betrag, 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='Nahrungsmittel'
		AND t1.BDatum>='01.03.2004'
		AND t1.BDatum<='31.03.2004'
)
ORDER BY t1.BDatum ASC

Problem is, that I get alle records, but the restriction 
"t1.BDatum>='01.03.2004'" doesn't work correct. I get all records which 
have BDatum <='31.03.2004'.

when I use following Code

ELECT t1.BDatum, t2.Konto_Name, t3.Konto_Name, t4.Kategorie_Name, 
t1.Betrag, 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 ( t1.BDatum>='01.03.2004'
		AND t1.BDatum<='31.03.2004'
		AND t4.Kategorie_Name='Nahrungsmittel'
)
ORDER BY t1.BDatum ASC

everything is fine.

Is this a bug in valentina?

bye


Claudius

-- 
G4/733 QS / MacOS X 10.3.5de / RB 5.2.4de or 5.5.3/ Valentina 1.10.0
Homepage    http://www.ClaSai.de
Download    finale Versionen, Betaversionen auf der Homepage
RealBasic ListBoxes: [ I feel the need...the need for speed!!! ]