V4RB: problem with dates

[Ruslan Zasukhin]

On 9/19/04 3:27 PM, "Claudius Sailer" <Claudius at sailer-online.de> wrote:

> Hi Ruslan,
> 
> Am 19. Sep 2004 um 13:30 Uhr schrieb Ruslan Zasukhin:
> 
>> I think the first query will work if you add () around dates
>> 
>>> 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
> 
> thats true, but I am not the coder. The user can click the restrictions
> together and so I can get 3 different SQLString-Results and I would
> expect that the output result is also the same.
> 
> I am unable to catch this possibilities by reading the restricitons and
> build special rules too?
> 
> Will it with valentina 2.0 the same result or is there too differences
> in coding-sorting of restricitons?

2.0 use other algorithms here.


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------