To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=67592 Issue #|67592 Summary|filtered query error Component|Database access Version|OOo 2.0.3 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|fornarif
------- Additional comments from [EMAIL PROTECTED] Thu Jul 20 00:06:47 -0700 2006 ------- Hello, I found a second problem with queries, but this one affects also standard queries. I started with two tables with an inner join between their primary keys. Then I built a simple query with a few fields chosen from both tables, primary keys included. All worked well until I inserted two criterions as filter under the same field (OR condition). The query continue to work, but after closed and re-opened in Design View, it's structure was changed: the graphical line representing the relationship was missing and a new field was added to realize the same relationship. This way the query continue to work, but in Design View it appears almost confusing for any further reading and modification. Please, note that such a modification happens only with two or more criterion filter, whilst with one criterion only all remain unchanged. Attached, you can find a little sample database. Here is the correct SQL statement: SELECT "Cronologico"."DataReg", "Cronologico"."NumDoc", "Cronologico"."DataDoc", "TipiDocumento"."Documento", "Cronologico"."Imp", "Cronologico"."ImpND", "Cronologico"."FCIVA" FROM "TipiDocumento" AS "TipiDocumento", "Cronologico" AS "Cronologico" WHERE ( "TipiDocumento"."TipoDoc" = "Cronologico"."TipoDoc" ) AND ( ( "Cronologico"."TipoDoc" = 'PAI' ) OR ( "Cronologico"."TipoDoc" = 'PAE' ) ) and here is the SQL statemente as modified by Base: SELECT "Cronologico"."DataReg", "Cronologico"."NumDoc", "Cronologico"."DataDoc", "TipiDocumento"."Documento", "Cronologico"."Imp", "Cronologico"."ImpND", "Cronologico"."FCIVA" FROM "Cronologico" AS "Cronologico", "TipiDocumento" AS "TipiDocumento" WHERE ( ( "TipiDocumento"."TipoDoc" = "Cronologico"."TipoDoc" AND "Cronologico"."TipoDoc" = 'PAI' ) OR ( "TipiDocumento"."TipoDoc" = "Cronologico"."TipoDoc" AND "Cronologico"."TipoDoc" = 'PAE' ) ) Best regards, Franco --------------------------------------------------------------------- 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]