Bug #9797 BDE does not recognize datetime fields
Submitted: 10 Apr 2005 21:25 Modified: 11 Apr 2005 0:25
Reporter: Mehmet AVSAR Email Updates:
Status: Duplicate Impact on me:
None 
Category:Connector / ODBC Severity:S2 (Serious)
Version:3.51.10 OS:Windows (Windows XP SP1)
Assigned to: CPU Architecture:Any

[10 Apr 2005 21:25] Mehmet AVSAR 
Description:
I'm Using Delphi 6 (Build 163) and connecting to MySQL Server 4.1.9 through BDE. I'm having problem on tables which includes any datetime field. Datetime fields are not recognized by BDE and never can be listed on datasets just like they do not exist. Previously added fields raises an error like "Type mismatch on field 'WHATEVER'. Expected: TDateField, actual:Unknown". I've also tried to change TDateField to TDateTimeField manually, but does not work.

How to repeat:
Just create a table with any datetime field in. Create a system dsn on ODBC with default MyODBC flags. Create a Delphi project, use BDE's TDatabase and TTable Components. After setting properties to point the table, open the table's Field Editor and try to "Add All Fields".
[11 Apr 2005 0:25] MySQL Verification Team 
Same issue source as:

http://bugs.mysql.com/bug.php?id=9616