To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113631 Issue #|113631 Summary|Some Fields Not Displaying Properly in Subforms Component|Database access Version|OOO330m1 Platform|PC URL| OS/Version|Windows, all Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|MySQL Connector/OOo Assigned to|dbaneedsconfirm Reported by|steven_shelton
------- Additional comments from [email protected] Wed Aug 4 02:44:35 +0000 2010 ------- Note that this may be related to (or possibly a duplicate) of Issue 113149. This is a hard one to explain. In OOO330m2 (and the latest Dev-3.4 build), there is a specific subform field that remains blank when it should not. I have a form called "Billing and Time Tracking", which works perfectly fine. This form is duplicated as a subform in a form called "Case Details". The forms allow the user to select the specific client by either selecting the client's name from a dropdown menu, or directly entering the client's number. If the name is selected from dropdown, the "Client ID" field automatically updates with the correct client ID number. If the client ID number is entered directly, the "Client Name" dropdown jumps to the correct name. (Both actually draw on the "ClientID" field in a table called "Client Details".) The code in the dropdown is this: SELECT "ClientName", "ClientID" FROM "ClientDetails" "ClientID" This works perfectly well in all stable versions of OOo. The new nightlies and milestones introduce an error where the dropdown works fine in the mail form, but remains blank in the subform. I'm attaching some screenshots that show what I'm talking about. It should be noted that the actual selection works just fine; if you select a name from the dropdown, it actually does adjust the client ID number. It just doesn't display in the form field. This issue occurs both in embedded database files and in database files accessed via the java connector. --------------------------------------------------------------------- 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]
