To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=62771 Issue #:|62771 Summary:|SQL query in List content of Form listbox appears to |be corrupting Component:|Database access Version:|OOo 2.0.2 Platform:|PC URL:| OS/Version:|Linux Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|rosspjohnson
------- Additional comments from [EMAIL PROTECTED] Sat Mar 4 07:13:28 -0800 2006 ------- This was working in OOo2.0.1, but something has changed for OOo2.0.2RC4. In OOo2.0.2RC4 any SQL query entered into the List Content box of the ListBox Form control properties is being wrapped in double quotes. This appears to be causing the Listbox to fail where it comes up with no entries in the drop list. E.g. Typing: SELECT somefield FROM sometable is appearing as "SELECT somefield FROM sometable" List boxes created in OOo2.0.1 are still working fine, and the SQL statements are not wrapped in quotes. Combo boxes do not have this problem (not wrapped in quotes). --------------------------------------------------------------------- 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]