To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=59868 Issue #:|59868 Summary:|Repeated Column errors on editing Integer, Decimal, |Numeric data types Component:|Database access Version:|OOo 2.0.1 Platform:|PC URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|beaucoder
------- Additional comments from [EMAIL PROTECTED] Thu Dec 29 01:43:31 -0800 2005 ------- 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 --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
