Issue 62771 - SQL query in List content of Form listbox gets broken when using shift-enter
Summary: SQL query in List content of Form listbox gets broken when using shift-enter
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.0.2
Hardware: PC Linux, all
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2006-03-04 15:13 UTC by rosspjohnson
Modified: 2017-05-20 10:48 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Corrupt List content property demo (13.36 KB, application/vnd.sun.xml.base)
2006-03-07 14:01 UTC, rosspjohnson
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description rosspjohnson 2006-03-04 15:13:28 UTC
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).
Comment 1 rosspjohnson 2006-03-04 15:29:14 UTC
Actually, I can't confirm that Listboxes in OOo2.0.1 didn't also have this
problem - I thought I had used them but haven't and I can't recall if I tried
them or not. Combo boxes are definitely working ok.
Comment 2 rosspjohnson 2006-03-06 06:33:27 UTC
The problem has shifted now that I understand a bit more.

I had assumed list boxes work just like combo boxes by default. I think they
should. The cause of my problem, I believe, is that the Bound Field value equals
1 by default, which assumes that the list content is going to be generated by a
SQL statement like:

SELECT displayfield, boundfield FROM sometable

I.e. a linked reference list box.

If Bound Field is cleared, the select in my earlier comment works.

Can someone please check if Bound field is meant to be '1' by default? Or is it
an index off-by-one error and meant to be 0 (or empty)? Using '1' to refer to
the second select field surely confuses the average person. (Yes, I realise it's
a C thing).

Why the SQL query is wrapped in quotes is still odd. It seems to be a display
error in the property.
Comment 3 rosspjohnson 2006-03-07 14:00:09 UTC
I have attached an odb file that demonstrates corruption in the List box List
content property.

- Open the attached junk.odb.
- Edit the Orders form.
- Open the control dialog for the Order# list box.
- Look at the List content SQL query. You should see that it is missing the FROM
- Append "FROM "Stock Items" to the SQL query.
- Turn design mode off and check that the list box works.
- Save and exit the form editor.
- Reopen the form editor and check the List content property that you appended
to. You should see that the FROM clause is gone again.
Comment 4 rosspjohnson 2006-03-07 14:01:18 UTC
Created attachment 34632 [details]
Corrupt List content property demo
Comment 5 christoph.lukasiak 2006-05-09 11:29:52 UTC
change owner
Comment 6 christoph.lukasiak 2006-05-09 11:36:47 UTC
clu->rosspjohnson: if i understand you right, you loose your new inputted
properties - does it happen also with other settings in property browser (issue
63814)? if that is the case the workaround is to click into an other cell after
inserting your properties.

may you acknowledge that

Comment 7 rosspjohnson 2006-05-09 17:15:59 UTC
Issue 63814 doesn't solve this. However, I've just realised that my instructions
to reproduce the problem missed a crutial fact. The problem only seems to appear
if I add a newline (Shift+Enter) in the SQL query in the list content property box.

In the sample database, if I append 'FROM "Stock Items"' to the end of the
existing line it appears to remain unchanged through the save/close/(re)edit
cycle. If I type Shift+Enter to start a new line in the list box, and then type:

FROM "Stock Items"

then the FROM clause is removed again. That is, anything after the Shift+Enter
is removed. I checked this by appending 'FROM [Shift+Enter]"Stock Items"'.

I don't believe this is how it is meant to behave since it is inconsistent with
the Check box control and with other multiline property boxes where an SQL
statement can be entered.

However, the workaround in this one case does appear to be to avoid Shift+Enter
when entering an SQL statement.
Comment 8 Regina Henschel 2006-05-09 19:31:24 UTC
"shift-enter" is the point.

I use OOo 2.0.2 on WinXP. If I insert a shift-enter, then it becomes a ";" in
the SQL-string. If I reopen the file the string is cut at the first ;
It seems to get lost, when closing the file. If I extract the content.xml while
the file is open, the SQL-string is complete. If I extract it, after closing the
file, the SQL-string is cut in the content.xml.
Comment 9 christoph.lukasiak 2006-05-17 13:28:10 UTC
i can repro that like described
Comment 10 christoph.lukasiak 2006-05-17 13:29:42 UTC
change owner
Comment 11 Marcus 2017-05-20 10:48:11 UTC
Reset assigne to the default "".