Bug in FilterSQL ?

Bug in FilterSQL ?

Postby Hans » Sun 18 Dec 2005 10:14

Hi,

I believe there is a bug in FilterSQL. WHen I filter on a date it gives no result. When I use the same filter string with the Filter property it works?

Is this a bug or should I prepare the statement differend for FilterSQL?

Could someone tell me what property is advised to use FilerSQL or Filter?

Statement:

FilterSQL='END_DATE='2-2-2005''

best regards, Hans
Hans
 
Posts: 52
Joined: Wed 24 Aug 2005 20:05

Postby Ikar » Mon 19 Dec 2005 09:35

Problem is in DATE precision. For example, insignificant (for user) difference in one millisecond is significant for comaprison. To avoid the problem use '>=' operation instead of '='.
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56


Return to MySQL Data Access Components