Peter,

stupid me,  my rowset is client site

but the server site resultset gives also "93" as type

?
Peter ,

Thanks for the hint but no luick , the type in the rowset = 93 this gives and still a lot of "0"'s and no (null) in my table

as i use a SQL statement i do not alter the rowset but go over the active conection to the mySQL table. when is use the rowset service to update in stead off a direct SQL statement then the "column.updatnull" gives a (null) in the table. as the rowset service still gives problems i need to use SQLstatements to alter my tables "behind" the OO- rowset service runs also a "SQLstatement" : question is wath type is there used to set the right SQLtype ?

Thanks

Fernand
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


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org

Reply via email to