V4RB: date compare fault

[Ruslan Zasukhin]

on 2/2/03 1:17 PM, Claudius Sailer at Claudius at sailer-online.de wrote:

> Hi,
> 
> I have in the database following relations
> 
> t1 --> t2
> t2 --> t3
> t4 --> t3
> 
> and the following SQL-Statement works
> 
> SELECT t1.BDatum, t1.Betrag, t2.Kategorie_Name, t3.Bezeichnung,
> t4.Satz, t4.AnfangsDatum, t4.EndDatum
> FROM Buchungen t1, Kategorien t2, MWSt t3, MWStSatz t4
> WHERE t1.Kategorie_ID=t2.RecID
> AND t2.MWSt=t3.RecID
> AND t4.MWSt=t3.RecID
> 
> the following which I need not
> 
> SELECT t1.BDatum, t1.Betrag, t2.Kategorie_Name, t3.Bezeichnung,
> t4.Satz, t4.AnfangsDatum, t4.EndDatum
> FROM Buchungen t1, Kategorien t2, MWSt t3, MWStSatz t4
> WHERE t1.Kategorie_ID=t2.RecID
> AND t1.BDatum>=t4.AnfangsDatum
> AND t2.BDatum<t4.EndDatum
> AND t2.MWSt=t3.RecID
> AND t4.MWSt=t3.RecID
> 
> no try with comparing dates work.
> 
> SELECT t1.BDatum, t1.Betrag, t2.Kategorie_Name, t3.Bezeichnung,
> t4.Satz, t4.AnfangsDatum, t4.EndDatum
> FROM Buchungen t1, Kategorien t2, MWSt t3, MWStSatz t4
> WHERE t1.Kategorie_ID=t2.RecID
> AND t1.BDatum=t4.AnfangsDatum
> AND t2.MWSt=t3.RecID
> AND t4.MWSt=t3.RecID
> 
> this shows me the correct result, but comparing without equal gives me
> no result...
> I tested all possibilities with brackets without any better result. Any
> idea how I can handle or fix this in RB to make it usable? My idea was
> to fill a new table without the Date-restriction and use a
> delete-Statement afterwords with a date restriction, but is it much
> more easier to come to the same result?

Hi Claudius,

As far as I see problem not in date comparison,
Problem is that you compare by '>=' fields form different tables.

> AND t1.BDatum>=t4.AnfangsDatum

NOT IMPLEMENTED in current version.

Only operator = works.


-- 
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://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------