Frank Sch�nheit - Sun Microsystems Germa ny ([EMAIL PROTECTED]) wrote: > > Hi Brian, > > > I copied the code into a macro and hit run basic and I get a > > NoSuchElelmentException error on > > databaseDocument = databaseContext.getByName( databaseURLOrRegisteredName ) > > Did you adjust the "databaseURLOrRegisteredName" value in line 5 of the > macro? To an URL or to a registered name? >
No. I don't have an URL or registered name. When I'm just making queries and forms within the oo.org native database file itself, do I still have to register it? I couldn't find much information about what registering really did or how to do it in a current version. > > I also tried the call > > "org.hsqldb.Library.getFullDatabaseProductVersion"()SQL > > from that page and get error: syntax error, unexpected $end, expecting > > BETWEEN > > or IN or SQL_TOKEN_LIKE > > Press the "Run SQL Direct" button in the toolbar before executing the > macro. This is a highly HSQL-specific SQL statement, so Base's parse > (which is invoked unless you press this button) is not able to cope with it. > > Ciao > Frank > I did this command in the query window as instructed by that web page, pressed the "Run SQL Direct" button, and get an error: Unknown function: getFullDatabaseProductVersion in statement [call "org.hsqldb.Library.getFullDatabaseProductVersion"()] -- Brian Johnson, P. Eng Johnson Engineering Consultants http://johnson-engineering.ca Ontario, Canada --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
