Hi Fernand,
> >>>> oStatement.setNull(1,1111 ) for a "textfield" works fine (1111 = > long > >>>> SQLType "others") > >>>> oStatement.setNull(2,1111 ) for a "timestamp" returns "00-00-00 > >>>> 00:00:00" and not the Mysql (null) > >>>> > >>>> i tried SQLtype 0 also with same results > >>>> Is this not a bug in that version (which one, by the way) of the ODBC driver ? I have had this problem for a long time, and it has caused me no end of trouble, for example when I switched to the JDBC driver and it couldn't handle default 0000-00-00 strings. It occurs on my system because I have set the default value of my date fields to be NULL in the create table statement. Even my current MySQL Query Browser client has problems with this and throws an error. Alex --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org