MySQL Bugs: #9616: Conflict with BDE 5.01 and Connector MyODBC-3.51.11-1

Bug #9616	Conflict with BDE 5.01 and Connector MyODBC-3.51.11-1
Submitted:	4 Apr 2005 17:00	Modified:	27 Aug 2007 10:09
Reporter:	Roberto Valente	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	Connector / ODBC	Severity:	S1 (Critical)
Version:	3.51	OS:	Windows (WINDOWS 2K/XP)
Assigned to:		CPU Architecture:	Any

Description:
There is a conflict with DATETIME field in the following situation:

A Delphi Application
Oppening a TABLE component
with BDE 5.01 
and connector MyODBC-3.51.11-1

The TDATETIMEFIELDS are not recognized

This doesn´t happens with MyODBC-3.51.10 connector
With BDE 4.0 this conflict doesn´t happens also

How to repeat:
Create a TTable Component at a Delphi Application
Select a Table with a DATETIME field
Open the table

(the field won´t appear in field list)

Suggested fix:
Use the older connector 
(MyODBC-3.51.10)

Could you please verify if the DATE column is sending as TEXT or STRING
column in this case is a duplicate bug.

Thanks in advance.

In this case, oppening with delphi´s TTable Component then
result is UNKNOWN
please see image at link below
www.hypertech.com.br/imagens/tables.jpg

When i run a Query, the result is DATEFIELD

Using Delphi 2006, BDE version 5.2, the 3.51.12 MySQL ODBC driver on Windows XP, I can not reproduce this problem.

I do have an ODBC problem with dates that I will report in another issue, but was trying to understand if this problem is connected to the problem I have.

Hello all.

I can't repeat reported behavior using:
 - MySQL server 4.1.22-log and 5.0.48-pb1038-log MySQL Pushbuild Edition, build 1038 on WinXP Pro SP2 localhost
 - MyODBC 3.51.19GA
 - BDE 5.0.1 and Delphi 6 build 6.240 update pack 2

mysql> show create table tblzaliha\G
*************************** 1. row ***************************
       Table: tblzaliha
Create Table: CREATE TABLE `tblzaliha` (
  `ID` int(10) unsigned NOT NULL auto_increment,
  `DokID` int(10) unsigned default NULL,
  `TipDok` enum('-','BLABLA') defa
ult NULL,
  `TipSkl` enum('XX','YY') default NULL,
  `DatumDok` date default NULL,
  `StatusDok` tinyint(3) unsigned default NULL,
  `Promjena` timestamp NOT NULL default '0000-00-00 00:00:00',
  `Godina` year(4) default NULL,
  `ArtiklID` int(10) unsigned default NULL,
  `Kolicina` decimal(12,4) default NULL,
  `MT` int(10) unsigned NOT NULL default '129',
  `OrgDokID` int(10) unsigned default '0',
  PRIMARY KEY  (`ID`),
  KEY `KEY_DokID` (`DokID`),
  KEY `KEY_DatumDok` (`DatumDok`),
  KEY `KEY_Godina` (`Godina`),
  KEY `KEY_ArtiklID` (`ArtiklID`),
  KEY `KEY_FULL` (`DatumDok`,`Godina`,`ArtiklID`,`Kolicina`)
) ENGINE=MyISAM AUTO_INCREMENT=32354 DEFAULT CHARSET=latin1
1 row in set (0.00 sec)

mysql>

-----
  object Table1: TTable
    Active = True
    DatabaseName = 'duc129'
    TableName = 'tblzaliha'
    Left = 216
    Top = 44
    object Table1ID: TIntegerField
      FieldName = 'ID'
    end
    object Table1DokID: TIntegerField
      FieldName = 'DokID'
    end
    object Table1TipDok: TStringField
      FieldName = 'TipDok'
      FixedChar = True
      Size = 10
    end
    object Table1TipSkl: TStringField
      FieldName = 'TipSkl'
      FixedChar = True
      Size = 2
    end
    object Table1DatumDok: TDateField
      FieldName = 'DatumDok'
    end
    object Table1StatusDok: TSmallintField
      FieldName = 'StatusDok'
    end
    object Table1Promjena: TDateTimeField
      FieldName = 'Promjena'
      Required = True
    end
    object Table1Godina: TSmallintField
      FieldName = 'Godina'
    end
    object Table1ArtiklID: TIntegerField
      FieldName = 'ArtiklID'
    end
    object Table1Kolicina: TFloatField
      FieldName = 'Kolicina'
    end
    object Table1MT: TIntegerField
      FieldName = 'MT'
      Required = True
    end
    object Table1OrgDokID: TIntegerField
      FieldName = 'OrgDokID'
    end