To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107627 Issue #|107627 Summary|Alert when user attempts to create relation between 2 |fields of same type but different length. Component|Database access Version|OOO320m7 Platform|PC URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|sak102010
------- Additional comments from [email protected] Fri Dec 11 22:16:38 +0000 2009 ------- Generate an alert when a user attempts to create a relationship between two fields that are of the same type, but have different lengths. The example I recently encountered was in the creation of a small project management database. I created a Status table, with a single field Status (Text [VARCHAR]). The length was set to 100, and I populated the table with various statuses that can be assigned to a particular task. In the Tasks table, I added a field for Status (Text [VARCHAR]), and accidentally set the length value to 10. In the relationships editor, I was able to assign the relationship between Status.Status and Tasks.Status, but didn't run into the problem until I setup a combobox on my Tasks form for selecting a status to assign to a particular task. When attempting to select a status that was longer than 10 characters, the form would generate an error. My thought was that there should have been an error earlier, when I attempted to create the relationship, informing me that the two fields were of different length values. --------------------------------------------------------------------- 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]
