To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=99277 Issue #|99277 Summary|Query loses alias if something changed in Field at Des |ign View Component|Database access Version|OOO310m1 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|ud
------- Additional comments from u...@openoffice.org Mon Feb 16 21:36:18 +0000 2009 ------- If you create a query in Design like "Field" || 'Test' || "Filed2" or "Field" + "Filed2" an set an alias, the alias is bound to the query. But if you change something in "Field" + "Filed2" like "Field" - "Filed2" or so after an alias name was set, the name is lost. You get it first, if you run the query again, because it would be shown right in the alias row. If you dont know what i mean, please open the attached database -open Query "lose alias" to edit in Design View -run the Query => notice that <Im away if somthing change in Field> is displayed as column header - change something in the <Field> row e.g. put one more Letter in -run the query => notice that <Im away if somthing change in Field> isnt displayed anymore in the column header, but displayed in the <Alias> row. -click once in the <Alias> row => notice that <Alias> row is now empty. I remeber this in most/all Base versions 2.0 --------------------------------------------------------------------- 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