MySQL Bugs: #2468: Problem with TTable.Filter concerning a date field

Bug #2468	Problem with TTable.Filter concerning a date field
Submitted:	21 Jan 2004 6:49	Modified:	30 May 2013 11:48
Reporter:	Ioannis Paizis	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / ODBC	Severity:	S2 (Serious)
Version:	ODBC Driver 3.51.06	OS:	Windows (Windows 98&XP)
Assigned to:		CPU Architecture:	Any

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'

Suggested fix:
?

Unlucky I don't have Delphi for to make the best test that I can
however I tested MyODBC with another third application like
Access 2003 filtering date fields and I didn't find any problems.
Then I suggest you for to verify if on your machine is already
installed the latest Microsoft MDAC library, if no, then please
try it or contact the Borland's support if they know some bug already
reported between MyODBC <> Delphi about this issue.
Thanks.

I have been having this exact same problem with my Borland/MySQL database application. I can filter a string just fine, but a date gives an "Operation not applicable" error. How do I fix this? It's been three friggin' years since the bug was initially reported, so you'd think that some solution would have surfaced by now, right?

Thank you for your bug report. This issue has already been fixed in the release version of that product, which you can download at

  http://www.mysql.com/downloads/