To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=89534
------- Additional comments from [email protected] Thu May 28 14:07:24 +0000 2009 ------- Hello, I followed the instructions given and it didn't work. The topic is an important one since it implements SQL functions quite basic in a database engine. The point is raised here: http://user.services.openoffice.org/en/forum/viewtopic.php? f=61&t=5764&p=26729&hilit=DATE_ADD+alternative#p26729 how can one do date arithmetics in hsqldb engine? Villeroy answers sharing a Java library from author Ariel Constenla-Haile containing the DATEADD and TIMEADD functions: http://user.services.openoffice.org/en/forum/download/file.php?id=1137 and giving the needed instructions (SQL instruction to create an alias so that the library code is called via the DATEADD/TIMEADD SQL command), but adds he can't have it working and thus he's filed issue about it here: http://qa.openoffice.org/issues/show_bug.cgi?id=89534 http://www.openoffice.org/issues/show_bug.cgi?id=89534 where the trail appear to end up. In this issue page, Arielch and Fs provide further needed instructions: Fs points out there are configuration settings to set in order to allow library code execution, and mentions DataAccess.xcs as the config file in point. Arielch provides the related XML configuration settings needed, and seemingly mentions DataAccess.xcu as the config file in point, then labels the issue CLOSED INVALID. To sum it up, I: - Downloaded and put on the machine as a .jar file the java library. - Updated either/both DataAccess.xcs and DataAccess.xcu with the given XML settings in proper position. - Linked the java library in Base via Main Menu>Tools>Options>Java>Class Path.. - Restarted the whole stuff. Still get the well aforementioned message: "Access denied: ar.com.arielconstenlahaile.dbextras.funcsql.Fechas.agregarFecha in statement [SELECT DATEADD( 'dd', 10, "datefield" ) FROM "Table"]" Where did I go wrong? --------------------------------------------------------------------- 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]
