MyDAC 5.10 strange data type result on mysql select constants

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
farhad
Posts: 7
Joined: Mon 14 May 2007 17:37

MyDAC 5.10 strange data type result on mysql select constants

Post by farhad » Wed 01 Aug 2007 03:48

On BDS 2006, MyDAC 5.10 and MySQL 4.1.16, when I open a query like "SELECT 1 AS a" I get returned field "a" in ftBoolean DataType !... In fact for any constant from 0 to 9 I get ftBoolean, but from 10 up the result is ftLargeInt. Example "SELECT 0 AS a, 5 AS b, 10 AS c", fields "a" and "b" are returned in ftBoolean, but field "c" is in ftLargeInt. I switched back to MyDAC 5.00, its ok and all fields are returned in ftLargeInt.
Have I missed any settings?
Thanks for any ideas.
Top
Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Wed 01 Aug 2007 14:09

This is a known problem of MyDAC. It will be fixed in the next MyDAC build.
Top
farhad
Posts: 7
Joined: Mon 14 May 2007 17:37

Post by farhad » Wed 01 Aug 2007 14:32

Thanks for the feedback.
Top
Post Reply

Return to “MySQL Data Access Components”