Re: Problem with subforms in 2.0.4 in Fedora Core 6

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