MyDAC V3.50.0.18 connect to MYSQL 5.0.3-beta some datatype unknow?

[Chin]

If column type is Decimal(20,8), error prompt out unknow datatype.

Direct/Client Dll mode also got problem.

May i know what version will be fully suppot MYSQL v5.0.3-beta.

[Ikar]

The problem is in the last changes at data types of MySQL 5.0.3. MyDAC 3.50 doesn't support these changes.

> May i know what version will be fully suppot MYSQL v5.0.3-beta.

In one-two month we are planning to release MyDAC 4.0 that will fully support MySQL 5.0.3.

[Ikar]

Support of the new format of DECIMAL-fields in MySQL 5.0.3 will be included to the next build of MyDAC 3.50. Roughly speaking, we are planning to release it at the end of April.

[Jeffl]

I have a query with a conditional (if) that returns text flags. With mysql 5.04Beta-NT I get an Unknown Mysql data type error.
Changing the TMyQuery FieldAsString flag to TRUE removes this error.
Not tested with 3.50 yet, but this also returned an error (Read out of sequence) which is why I went back to 3.10.1.6
SQL posted below

Code: Select all

select TL_LINE_NO,PSD_MODEL,IF(PSD_DATE_READY<TL_FOB_DATE_MAX,'ON TIME','LATE')'READY_STATE', IF(PSD_DATE_READY<TL_FOB_DATE_MAX,sum(PSD_QUANTITY) ,sum(PSD_QUANTITY))'INDIVIDUAL_UNITS'  from prod_schedule_detail 
left join track_line on PSD_LINE_LINK=TL_LINE_NO

where
 PSD_TRACK_ID=:TR_ID
and TL_TRACK_ID=:TR_ID

and PSD_ID not in (select PSD_SEQ from prod_schedule_detail)
and PSD_DELETED='N'


and TL_ID not in (select TL_SEQ from track_line)
and TL_DELETED='N'

group by TL_LINE_NO,IF(PSD_DATE_READY<TL_FOB_DATE_MAX,'ON TIME','LATE')
[b]

[/b]

[Ikar]

Try to download MyDAC last version (3.50.0.20). If problem persists then send us complete small sample to demonstrate it and include script to create and fill tables.