To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=106285 Issue #|106285 Summary|Queries lost alias keyword "AS" after closing query an |d file Component|Database access Version|OOo 3.2 Beta 1 Platform|Unknown URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|r4zoli
------- Additional comments from [email protected] Mon Oct 26 13:17:45 +0000 2009 ------- It is the same in all version I tested. 3.1.1 and 3.2 Beta: Queries lost alias keyword "AS" after closing query and file. Similar problems can be fouund in issues (if you see into SQL commands inserted into issues text): issue: 50175 Error in Query Design with Aliases and Sorting (Status:WORKSFORME) issue: 97948 Query designer does not include table alias in ORDER BY clause (Status:NEW) issue: 104961 Database query design view generates extra unusable SQL text (Status:INVALID) (ODBC connection) May be this issue generated my issue on hsqldb conversion issue: 105915 I tried with file attached to issue: 105907 If you open nFonok view the SQL code: SELECT CASE WHEN "KozepNev" <> '' THEN "Vezeteknev" ||', '|| "Utonev" || ' ' || SUBSTR("KozepNev",1,1) ELSE "Vezeteknev" ||', '|| "Utonev" END AS "Nev", "AlkalmazottKod" FROM "Alkalmazott" "Alkalmazottak" If you run this query/view it runs, but conversion failed as described in issue 105915. If you looks into details you can find that in FROM clause missing "AS" keyword. I created a query with query wizard: SELECT "Vezeteknev" AS "Vezeteknév", "Utonev" AS "Utonév", "Telefonszam" AS "Telefonszám", "IrodaHely" AS "Iroda" FROM "Alkalmazott" AS "Alkalmazott" ORDER BY "Vezeteknév" ASC, "Utonév" ASC Close the query, save file, reopen file. Open query in design view and you get: SELECT "Alkalmazott"."Vezeteknev" AS "Vezeteknév", "Alkalmazott"."Utonev" AS "Utonév", "Alkalmazott"."Telefonszam" AS "Telefonszám", "Alkalmazott"."IrodaHely" AS "Iroda" FROM "Alkalmazott" "Alkalmazott" ORDER BY "Vezeteknev", "Utonev" >From the FROM clause missing "AS". Switch Design View on/off, the missing "AS" returns: SELECT "Vezeteknev" AS "Vezeteknév", "Utonev" AS "Utonév", "Telefonszam" AS "Telefonszám", "IrodaHely" AS "Iroda" FROM "Alkalmazott" AS "Alkalmazott" ORDER BY "Vezeteknév" ASC, "Utonév" ASC If you use this query as source for report, it is cause problem in reports, too. --------------------------------------------------------------------- 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]
