Bug in FilterSQL ?

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 52
Joined: Wed 24 Aug 2005 20:05

Bug in FilterSQL ?

Post by Hans » Sun 18 Dec 2005 10:14


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?



best regards, Hans

Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by 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 '='.

Post Reply