Min, Max value from MYSQL 4.1.8 and ODBC 3.51.10

Hello all,

I would like to ask you for help with this query. I use VB6 and MyODBC
3.51.10 connection. Problem is that, return value from query :

select min(date1) as MinDate, max(date2) as MaxDate from tabledata

is null for MinDate, but OK value for MaxDate. Could you describe to me, why
? Could you give me some advice for solution. ( Table definition is below )

Table definition :

CREATE TABLE `tabledata` (
`id` int(11) NOT NULL auto_increment,
`date1` datetime NOT NULL default '0000-00-00 00:00:00',
`date2` datetime NOT NULL default '0000-00-00 00:00:00',
`locplace` char(3) NOT NULL default '-',
`host` varchar(15) default '000.000.000.000',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


Many thanks.

Lubomir


************************************************************ **********************************
The information contained in this message or any of its attachments may be confidential and is intended for the exclusive use of the addressee(s). Any disclosure, reproduction, distribution or other dissemination or use of this communication is strictly prohibited without the express permission of the sender. The views expressed in this email are those of the individual and not necessarily those of Sony or Sony affiliated companies. Sony email is for business use only.

This email and any response may be monitored by Sony United Kingdom Limited.
(05)
************************************************************ **********************************


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org