To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=58140 Issue #:|58140 Summary:|IT: Incorrect translation in Base produces invalid |SQL ("Somma") Component:|Database access Version:|OOo 2.0 Platform:|PC URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|iano Reported by:|pescetti
------- Additional comments from [EMAIL PROTECTED] Fri Nov 18 13:44:30 -0800 2005 ------- Base IT translates the SQL SUM function into SOMMA, thus producing invalid SQL. Steps to reproduce: 1. Create a new database in Base IT. 2. Create a new table with a numeric named "quantity". 3. Insert two records: "10"; "15". 4. Create a query in Design View (this problem only affects Design View). 5. Drag and drop "quantity" in the first column. 6. Select Somma ("Sum") as the function for "quantity". 7. Save and run the query. 8. You get the error "Termine inaspettato: SOMMA in statement [SELECT Somma("quantity") FROM "Tabella1" "Tabella1"]" ("Unexpected term: SOMMA"...) SOMMA is indeed unexpected because it should be left as SUM and there is no reason to translate it into Italian. [Reported by Marco Caresia and Filippo Cerulo to the Italian QA team] --------------------------------------------------------------------- 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]