https://bugs.documentfoundation.org/show_bug.cgi?id=145212
Bug ID: 145212
Summary: Base, Form, Combobox element retains wrong data after
a multiple violation of foreign key constraint
Product: LibreOffice
Version: 7.0.6.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: intmai...@gmail.com
Description:
The Combobox element retains wrong data which not exists in the foreign key
constraint.
An user may be troubled to choose the right data after making many mistakes (he
did or others did). The combobox should display only data in foreign key
constraint and forget inappropriate data.
Steps to Reproduce:
1- Create a Push Button element to save the updated line. Properties is "Action
... Refresh form"
2- The form properties is set to always point to a fixed line of the table
(this is my case). Set "Filter" to do this.
3- Create a combobox , set "Type of list contents ... SQL" then set "List
content ..."
4- From keyboard, insert many wrong data followed each time by pushing the Push
button --> error message box appears each time because of foreign key
violation.
5- Check the combobox by dropdown it --> all wrong data remains in it
6- Close the form , re open the form --> wrong data disappears from the
combobox
Actual Results:
Inappropriate data remains (not permanently) in the combobox
Expected Results:
Display only data according to foreign key constraint
Reproducible: Always
User Profile Reset: Yes
OpenGL enabled: Yes
Additional Info:
Version: 7.0.6.2
Build ID: 144abb84a525d8e30c9dbbefa69cbbf2d8d4ae3b
CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3
Locale: fr-FR (en_US); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
