🚀 go-pugleaf

What is the back-end database?  Some ODBC drivers (I believe MySQL is among 
them) have trouble with NULL date values.

Mark

"crhras" <crhras@sbcglobal.net> wrote in message 
news:44e52431$1@newsgroups.borland.com...
>
> Can someone please explain why the following occurs ?
>
> The first table gives E_FAIL whenever the table is opened and at least one 
> record is "000-00-00 00:00:00".  The second table works just fine.  The 
> second table is exactly the same as the first except DTime is declared as 
> NOT NULL.
>
> --
> -- broken table
> --
> CREATE TABLE  tt (
>  serial            int(10) unsigned NOT NULL auto_increment,
>  DTime         datetime NOT NULL default '0000-00-00 00:00:00',
>  val               int,
>  PRIMARY KEY (serial)
> )
> ;
>
> --
> -- good table
> --
> CREATE TABLE  tt (
>  serial            int(10) unsigned NOT NULL auto_increment,
>  DTime         datetime default '0000-00-00 00:00:00',
>  val               int,
>  PRIMARY KEY (serial)
> )
> ;
>
> Thank you,
> Curt
>
>