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

chihebbs · Post by **chihebbs** » Wed 18 Jun 2008 18:33

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.

Dimon · Post by **Dimon** » Thu 19 Jun 2008 09:28

Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next MyDAC build.

chihebbs · Post by **chihebbs** » Thu 19 Jun 2008 14:24

Thank's Dimon.

alf.krause · Post by **alf.krause** » Fri 27 Jun 2008 12:52

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

Dimon · Post by **Dimon** » Thu 03 Jul 2008 06:42

We plan to release the next MyDAC build next week.