To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=54978 Issue #:|54978 Summary:|Query fail in query design window with a field with |the same name in more than one table Component:|Database access Version:|OOO 2.0 Beta2 Platform:|All URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P2 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|josemi
------- Additional comments from [EMAIL PROTECTED] Thu Sep 22 09:46:05 -0700 2005 ------- Designing a query with design wizard, if you put in a condition row from a column a parámeter, and this column name could be from more than 1 tables, don't generate SQL instruction correctly, because miss the table name. If you try execute the query, fails because the field name is ambigous. furthermore, if you generate the SQL instruction by hand, and write correctly the WHERE clausule including de table name, all is ok. But if you try later edit with desing wizard the SQL instruction you write, then lost the table name too. --------------------------------------------------------------------- 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]
