To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=81891 Issue #|81891 Summary|Standard filter fails in query if fields in two tables | have same names Component|Database access Version|OOo 2.2 Platform|All URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P2 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|mlebek
------- Additional comments from [EMAIL PROTECTED] Mon Sep 24 12:08:02 +0000 2007 ------- If fields in different tables have the same name and the fields are related, it is not possible to use the standardfilter with more than one criteria in a query. I allways get the following error: SQL-Status: 37000 Fehler-Code: -16 Wrong data type: java.lang.NumberFormatException: For input string: "Herr" in statement [SELECT "Haupttabelle"."Name", "Anrede"."Anrede", "Titel"."Titel" FROM "Haupttabelle", "Anrede", "Titel" WHERE ( ( "Haupttabelle"."Anrede" = "Anrede"."ID" AND "Haupttabelle"."Titel" = "Titel"."ID" ) ) AND ( ( "Anrede" LIKE 'Herr' AND "Titel" LIKE 'Prof.' ) )] I changed the names in Haupttabelle from 'Anrede' to 'Anrede-ID' etc, now it works. (in german: Haben Felder von 2 Tabellen den gleichen Namen, und sind diese Felder mit einer Relation 1:n verknüpft, dann ist es in einer Abfrage nicht möglich, den Standardfilter mit mehr als einem Kriterium auszuführen. Offenbar greift der Standardfilter auf die falsche Tabelle zu. Ändert man den Namen des Feldes, dass den Index des referenzierenden Wertes enthält, funktioniert der Standard-Filter) --------------------------------------------------------------------- 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]