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]

Reply via email to