To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=24079
------- Additional comments from [EMAIL PROTECTED] Mon Feb 25 00:18:52 +0000 2008 ------- Tested w/ XP, OOo 2.4 RC1, MySQL 5.0.11, MyODBC 3.5.1 I created two tables in the MySQL database to per the instructions. The first attachment is a screen shot of the query designer, before it is saved. This is SQL statement generated: SELECT `names`.`countryname`, `names`.`namestatus`, `countries`.`dummy` FROM `test`.`countries` AS `countries`, `test`.`names` AS `names` WHERE `countries`.`countryid` = `names`.`countryid` AND ( `names`.`namestatus` = 'A' AND `names`.`countryid` = 3 OR `names`.`countryid` = 4 OR `names`.`countryid` = 7 ) Attachment 2 is a screen shot of the query designer after saving and reopening the query. And the SQL generated now: SELECT `names`.`countryname`, `names`.`namestatus`, `countries`.`dummy` FROM `test`.`countries` AS `countries`, `test`.`names` AS `names` WHERE ( `names`.`namestatus` = 'A' AND `countries`.`countryid` = `names`.`countryid` AND `names`.`countryid` = 3 OR `countries`.`countryid` = `names`.`countryid` AND `names`.`countryid` = 4 OR `countries`.`countryid` = `names`.`countryid` AND `names`.`countryid` = 7 ) Not sure how this is fixed? --------------------------------------------------------------------- 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]
