Apache OpenOffice (AOO) Bugzilla – Issue 59868
Repeated Column errors on editing Integer, Decimal, Numeric data types
Last modified: 2006-05-31 14:29:06 UTC
Using MySQL or JDBC drivers for MySQL tables. Cannot edit a table if it contains Integer, Decimal or Numeric columns. Error: SQL Status: S1000 Unknown type '246 in column 6 of 14 in binary-encoded result set. Error constantly appears on trying to edit/insert rows in the table. If ALL columns are Varchar, for example, NO errors occur on edit/insert. Changing the table layout and setting any column from Varchar to one of the numerics (Integer, Decimal, Numeric) then invokes the error above if any numeric data exists in the column modified. If it is empty, I can edit the table and put a numeric value in the column. But after closing the table and attempting to edit/insert into the table again I will repeatedly get the above error. How to fix? Workaround?? Thanks, Ken Wagner
what jdbc driver do you use (ver. number)?
Can't reproduce with OOo2.0.2rc3 x JDBC connector 3.1.12. Ignoring the extreme slowness here, there's no error editing values in Integer columns. beaucoder, can you, please, try with latest version ? thank you. Hwoarang
does this problem still occure - please send more details
Closing due lack of information. Reopen it if necessary. Hwoarang
closing.