To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=83769 Issue #|83769 Summary|WHERE clause incorrectly changed in bug doc's query Component|Database access Version|680m236 Platform|All URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P2 Subcomponent|none Assigned to|oj Reported by|fs
------- Additional comments from [EMAIL PROTECTED] Mon Nov 19 21:44:19 +0000 2007 ------- - open the bugdoc attached to issue 82233 (http://www.openoffice.org/nonav/issues/showattachment.cgi/48688/BirdDatabase.odb) - select "Queries" on the left hand side - in the context menu of query "User1SightingsList", choose "Edit in SQL View" => Note the WHERE clause in the statement reads (whitespaces added for better readability) ( "AOU Birdlist"."EnglishName" = "Sightings"."Bird Name" AND "Field Trips"."ID" = "Sightings"."Field Trip ID" AND "Locations"."LocationName" = "Field Trips"."Location" ) AND ( ( "Sightings"."User1Voice" = True ) OR ( "Sightings"."User1Sight" = True ) ) - switch to graphical design view and back => note the WHERE clause now reads ( "AOU Birdlist"."EnglishName" = "Sightings"."Bird Name" AND "Field Trips"."ID" = "Sightings"."Field Trip ID" AND "Locations"."LocationName" = "Field Trips"."Location" ) AND ( ( "Sightings"."User1Voice" = True AND "Sightings"."User1Sight" = True ) ) The new clause clearly has a different meaning, and will produce a different result. What makes this issue bad is that the change happens silently: as soon as you change *anything* in the query (for instance the tab window layout, or a similar UI setting), and save the query, the statement becomes corrupted. --------------------------------------------------------------------- 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]
