Re: ADO/MyODBC Error with TIME fields.

Hi,

> I have found the problem both in Mysql 4.0 and Mysql 4.1 (latest versions) 
> with InnoDB.
>
> Here is the table:
> -----------------
> CREATE TABLE `prueba` (`Doc` varchar(10) NOT NULL default '',
>                       `Time1` time NOT NULL default '00:00:00'
>                        ,PRIMARY KEY  (`Doc`)) TYPE=InnoDB;

According to our MyODBC gurus, there are may be several problems that 
affects you...

Please, try to use '1:00:00' or '01:00:00' when you are setting value for 
your `Time1` column below:

> 'This does not run
> MiSet.AddNew
> MiSet!Doc = "AA00123456"
> MiSet!Time1 = "01:00"

and test if it will make any difference.

Best regards,
-- 
Valeriy Kravchuk, Support Engineer
MySQL AB, Kiev, Ukraine, www.mysql.com

Are you MySQL certified?  www.mysql.com/certification 


-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]