To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=53187 Issue #:|53187 Summary:|MySQL field names with spaces cause incorrect query Component:|Database access Version:|current Platform:|All URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|gsking1
------- Additional comments from [EMAIL PROTECTED] Wed Aug 10 12:01:47 -0700 2005 ------- Queries are only 'select all'(Select *), data cannot be edited, and tables cannot be edited, when mysql table field names have blank spaces in them. For example field name "Monthly Sales" causes problems, while "Monthly_Sales" is fine. I am able to use spaces in field names using other utilities that access MySQL (eg. MS access and navicat). The workaround is to change database field names to include no spaces in all tables using pure SQL or other utility such as navicat. If this is not fixed, there should at least be a warning or notes about this irregulatity in the help manual. This is present on 1.9.122 on windows. Not sure about previous versions or platforms. Thanks for all your great work with OO! --------------------------------------------------------------------- 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]
