Hi Fernand, did you query for the type of the column?
resultSet.columns.getByName("myCol").Type?
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
Regards Peter --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org