V4RB Bug in SQL-Statement?

[Ruslan Zasukhin]

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

> Hi,
> 
> I have the following SELECT-Statements
> 
> 
> SELECT ZK.AnfangsZeit, ZK.EndZeit, ZK.AbrechnungsSatz, P.ProjektName
> FROM ZeitKonto ZK, Projekt P
> WHERE ZK.Projekt=P.RecID"
> AND ZK.Auftraggeber='2'
> AND ZK.AnfangsZeit>=01.01.2003
> AND ZK.AnfangsZeit<01.01.2004
> AND P.RecID='+RecID+'
> ORDER BY P.ProjektName
> 
> RESULT= 200 Records = CORRECT
> 
> 
> SELECT ZK.AnfangsZeit, ZK.EndZeit, ZK.AbrechnungsSatz, P.ProjektName
> FROM ZeitKonto ZK, Projekt P
> WHERE ZK.Projekt=P.RecID"
> AND ZK.Auftraggeber='2'
> AND P.RecID='+RecID+'
> AND ZK.AnfangsZeit>=01.01.2003
> AND ZK.AnfangsZeit<01.01.2004
> ORDER BY P.ProjektName
> 
> RESULT= 1200 Records = WRONG
> 
> Valentina ignores in the second SQL-Statement
> 
> AND ZK.AnfangsZeit>=01.01.2003
> AND ZK.AnfangsZeit<01.01.2004

Claudius,

This is old known issue.
You need group conditions for ZK table together.


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