Bug #57301 filterin dates in mysql
Submitted: 7 Oct 2010 9:05 Modified: 29 May 2013 5:55
Reporter: JJ JJ Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / ODBC Severity:S3 (Non-critical)
Version:3.51.06 OS:Any
Assigned to: Bogdan Degtyariov CPU Architecture:Any
Tags: regression

[7 Oct 2010 9:05] JJ JJ
Description:
I use Delphi 7, ODBC Driver 3.51.06 in Win98 and WinXP
Using a TTable.Filter concerning a date field I get [Operation not applicable] error. For
example TTable.Filter='THEDATE=1/1/2004'
Also note, that in the older version ODBC Driver 2.5... the problem DOESN'T EXIST !!! the
filter works ok !

How to repeat:
For example TTable.Filter='THEDATE=1/1/2004'
[8 Oct 2010 7:25] Bogdan Degtyariov
Hi JJ,

Connector/ODBC 3.51.06 is a very old version, which possesses many unresolved problems. Have you tried 3.51.27?

http://dev.mysql.com/downloads/connector/odbc/3.51.html

or 5.1.7

http://dev.mysql.com/downloads/connector/odbc/5.1.html

Please let me know how these versions work for you.
Thanks.
[9 Nov 2010 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[29 May 2013 5:55] Bogdan Degtyariov
I'm closing this bug because I can not continue without feedback from the reporter. If you have new info, please reopen the report.