field_date date not null default '0000-00-00'
Posted: 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.
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.