To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=89335 Issue #|89335 Summary|Query Wizard and Query Editor do not create valid SQL Component|Database access Version|OOo 2.4.0 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|tcrabb
------- Additional comments from [EMAIL PROTECTED] Mon May 12 15:06:16 +0000 2008 ------- This bug relates to Base in OOo 2.40, Windows XP. When creating a query which tests for NULL value of an integer field the generated SQL is all wrong. The Wizard creates "= 0" The GUI Query Editor creates "NULL" , appearing as EMPTY in the Query Editor ie missing "Is" before it so totally invalid statement is generated. Only by manually typing into the SQL View with "Is NULL" do you get the correct behaviour. (Aso now appears correctly as "IS EMPTY" in the GUI Query Editor). --------------------------------------------------------------------- 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]
