To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110274 Issue #|110274 Summary|Filling field in report gives wrong database update Component|Database access Version|OOO320m12 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P1 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|ptoye
------- Additional comments from [email protected] Sat Mar 20 15:57:17 +0000 2010 ------- I have a database form which has a control which is filled from a valuelist. Firstly, the values are not always displayed in the control (I've not been able to work out exactly when this happens). Secondly, and FAR more important, when entering the value which is last on the list, nothing is entered into the field in the underlying table, and when stepping through other records the data is DELETED from the table without any message being put onto the screen. Fortunately I had a backup of the original data. Demonstration: On the attached database, 1) Look at the table "Legatees" and the field "CollectionState". You will see that it is populated. 2) Open the form "Legatees". You will see that there is nothing in the Collection State control, although the values in the table field all appear in the ValueList for the control. 3) Then using the drop-down box set a value to "R". You will see that it does not appear in the control. 4) Then scroll through a few records. Look at the table. You will see that the value has disappeared from the field. OUCH!!! --------------------------------------------------------------------- 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]
