Page 1 of 1

Evolution: Set a default Date egal to -700000 instead 0

Posted: 08.08.2006, 07:06
by ddantoni
Hi,
is it possible to change the date default value or add possibility to change it inside zdbc config because lot of controls like DevExpress use -700000 value to specify NullDate.
Also DateToStr(-700000) return 00/00/0000.

Currently I modified MySQLResultSet.GetDate and changed Result := 0 to Result := -700000 if date was Null.

Thanks
David

Posted: 25.08.2008, 11:49
by ddantoni
Hello,
in the latest release, the default date value is always 0.
Is there anybody that had the same problem that me:
(MySQL date value for "0000-00-00" is defined to 0 and should be -700000)

Thanks
David