To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=61059 Issue #:|61059 Summary:|Line five of Query disappears in Design View leaving |it un-editable Component:|Database access Version:|OOo 2.0.1 Platform:|All URL:| OS/Version:|All Status:|NEW Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P2 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|phillg
------- Additional comments from [EMAIL PROTECTED] Mon Jan 23 07:47:03 -0800 2006 ------- Steps to reproduce: Open a new query to any existing DB. In the second column, add the the comparison "lines 1-6" on new lines (so as to get where field2 = 'line 1' or field2 = 'line2' ... 'line6' in the SQL). All six lines appear (screenshot 1) If you save the query of even come out of the design view and into the SQL view (screenshot 2, all where clauses present) and then go back you will notice that line five has disappear and will never come back (screenshot 3). This can cause huge problems if you back into a query and add extra fields or even another table as the result set is wrong and possibly huge (due to unlinked tables). I would argue that as line five actually disappears from being edited it constitutes data loss. --------------------------------------------------------------------- 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]