Page 1 of 1

field_date date not null default '0000-00-00'

Posted: Wed 18 Jun 2008 18:33
by chihebbs
Upgrading to version 5.50.0.34/35 when using TMyQuery with DefaultValues=true and a date field defined as field_date date NOT NULL default '0000-00-00' or Datetime not null default '0000-00-00 00:00:00'
MyQuery->Append() raises exception class EVariantTypeCastError with message 'Could not convert variant of type (String) into type (Date)'. and
next exception EDatabaseError with message 'Invalid value for field 'field_date''. whereas in versions till 5.20.0.15 the same situation was working without problems.
CodeGear Rad Studio 2007 C++
Windows XP Sp2
MyDac professional 5.50.0.35
Mysql 5.0.45
Please advice.

Posted: Thu 19 Jun 2008 09:28
by Dimon
Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next MyDAC build.

Posted: Thu 19 Jun 2008 14:24
by chihebbs
Thank's Dimon.

Posted: Fri 27 Jun 2008 12:52
by alf.krause
we have same problem - when is the next build ready for download?

The problem is on reading master detail with using the MyTable Component.

THX

Alf

Posted: Thu 03 Jul 2008 06:42
by Dimon
We plan to release the next MyDAC build next week.