Issue 53275 - Listbox values being deleted in form when listbox properties not set to "value list"
Summary: Listbox values being deleted in form when listbox properties not set to "valu...
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: 680m122
Hardware: All Windows 2000
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2005-08-13 15:49 UTC by helgekraak
Modified: 2013-02-07 22:42 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

Form document (9.89 KB, application/vnd.sun.xml.writer)
2007-09-18 11:34 UTC, helgekraak
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description helgekraak 2005-08-13 15:49:53 UTC
When you have a list box in a form and you enter the list entries manually while
the list entry type is set to SQL (without any SQL sequence typed in) you lose
the manually entered list entries after leaving the form edit mode and reopening
the form edit mode. This behaviour doesn't happen when you set the option "Value
list" instead of "SQL". Although this behaviour is contrary to the behaviour of
combo boxes (there you don't have the "value list" option and you can leave the
SQL option without anything happening as long as you don't type in a SQL
procedure) this wouldn't be such a big issue, but what irritates is that beside
the loss of the manually entered list box entries after leaving the form edit
mode the second time, you don't see the database column entries of this list box
field anymore when browsing between the datasets (I use HSQLDB attached to the
form via SQL in the form options). This seems to me to be a bug.

Best regards
Helge Kraak
Comment 1 christoph.lukasiak 2005-09-12 12:31:39 UTC
sad but true - but rather an enhancement, so send further to
Comment 2 helgekraak 2007-09-18 11:34:21 UTC
Created attachment 48302 [details]
Form document
Comment 3 helgekraak 2007-09-18 12:28:10 UTC
Sorry, please ignore attachment. Was not meant for this issue.