To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=58097 Issue #:|58097 Summary:|Unable to set columns to type decimal (MySQL/ODBC) Component:|Database access Version:|OOo 2.0 Platform:|All URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|kaimartin
------- Additional comments from [EMAIL PROTECTED] Fri Nov 18 03:07:04 -0800 2005 ------- My MySQL database contains currency values as "decimal(5,2)". If I connect via ODBC and use the wizard to set up the tables in openoffice, these columns get the type "Text(fix)[char]". It is possible to change the type to "decimal(5,2)" temporarily. However, this gets reset to "Text(fix)[char]" at the attempt to save the new table structure. If I try to insert a new column the type "decimal(5,2)" is correctly entered into the actual database. (Checked that with phpmyadmin). Still upon reopening the table editor insists, that this column is "Text(fix)[chr]". I would not care for the type of the table column. But if I try to set the monetary value via an open office form, it gets squashed to "NULL" on save. I guess this is because of the type mismatch as columns with type Text[varchar] in the same table can be set with no trouble at all. There is no error report on the failed submit. Using the type Text(fix) for monetary values in the first place, is no option either. This leads to truncation of results from arithmetics in SQL statements. (I will file a separate bug report on that). ---<(kaimartin)>--- PS: My system is linux, debian distribution. The installed package is openoffice 2.0.0-2 from the unstable branch. (Is this beta, or beta2?) --------------------------------------------------------------------- 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]
