To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=105915
User r4zoli changed the following:
What |Old value |New value
================================================================================
Status|NEW |RESOLVED
--------------------------------------------------------------------------------
Resolution| |INVALID
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Thu Oct 15 16:00:43
+0000 2009 -------
The view was wrongly created in older version (1.8) and it caused transformation
error. The view creation SQL Command:
SELECT CASE WHEN "KozepNev" <> '' THEN "Vezeteknev" ||', '|| "Utonev" || ' ' ||
SUBSTR("KozepNev",1,1) ELSE "Vezeteknev" ||', '|| "Utonev" END AS "Nev",
"AlkalmazottKod" FROM "Alkalmazott" "Alkalmazottak"
The last "Alkalmazottak" is not needed (field in this name not in the database
table).
And inserted into script this row (29):
CREATE FUNCTION PUBLIC."org.hsqldb.Library.getDatabaseFullProductVersion"()
RETURNS VARCHAR(32768) SPECIFIC
"org.hsqldb.Library.getDatabaseFullProductVersion_10054" LANGUAGE JAVA NOT
DETERMINISTIC NO SQL CALLED ON NULL INPUT EXTERNAL NAME
'CLASSPATH:org.hsqldb.Library.getDatabaseFullProductVersion'
If I removed "Alkalmazottak" from view creation command, file converted to new
version, OOo works correctly.
---------------------------------------------------------------------
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]
