To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=111143 Issue #|111143 Summary|Certain Column names can cause silent errors during da |ta posting causing data to written to wrong columns Component|Database access Version|OOO320m15 Platform|Unknown URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|atjensen
------- Additional comments from atjen...@openoffice.org Sun Apr 25 22:31:30 +0000 2010 ------- Could reproduce with OO.o 3.1.1 onwards (probably before) For example if a user creates 2 columns with names that differ only in case: T-Pain and T-PAIN This is valid for HSQLdb, and Base data controls will appear to work these columns, but during an update to the table the data is shifted to erroneous columns, for columns following the second instance of case insensitive string. If the data types of the misaligned data write are compatible, no error is given to the user - with one exception. There is a hint in the GUI when this is about to happen, the record number in the navigation bar will become inaccurate (always changing to 1) when a new value is written to a controls attached to one of these 'special' columns. NOTE - it appears that other strings can cause this also 'some:thing' and 'some/thing' may trigger it. To see this in action download the attached file, open the SOAP table in a dataview window - now near go to the end of the record, you will find the columns: Dx1, Dx2...Dx6 - write a value into these controls and update the table, you will see that the data moves to the right...on a forum with a lot of CHECKBOX controls this silent change can go on without catching the users attention. --------------------------------------------------------------------- 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: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org