Page 1 of 1

exception when Select Cast(field as X) as X w/ DefaultValues

Posted: Tue 11 Jan 2011 14:53
by Justmade
Latest MyDAC
MySQL 4.0.24
Delphi 2010

MyQuery.Options.DefaultValue = True

Select Cast(StrField AS SIGNED) AS aaa From Table;

---------------------------
Error
---------------------------

Can't find file: '.\database\aaa.frm' (errno: 22).
---------------------------
OK Details >>
---------------------------

It is not a big issue as disabling DefaultValue can solve it.
Just report it for your reference.

Posted: Wed 12 Jan 2011 13:32
by Dimon
Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next MyDAC build.