Page 1 of 1
MyDAC V3.50.0.18 connect to MYSQL 5.0.3-beta some datatype unknow?
Posted: Sat 02 Apr 2005 00:59
by 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.
Posted: Mon 04 Apr 2005 10:50
by 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.
Posted: Wed 06 Apr 2005 12:51
by 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.
A solution to Unknown datatype error
Posted: Fri 06 May 2005 08:44
by 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]
Posted: Fri 06 May 2005 12:53
by 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.