Re: Problem with subforms in 2.0.4 in Fedora Core 6

Frank Sch�nheit - Sun Microsystems Germa ny ([email protected])
wrote:
>
> Hi Brian,
>
> >>In case it's HSQLDB (look at the status bar of Base's application
> >>window), then this probably means you somehow use an older version of
> >>HSQLDB, which doesn't yet support named parameters (":link_from_brand").
> >>In this case, I assume you have a second - older - HSQLDB version in
> >>your system which interferes with the one provided by OOo (this
> >>interference will be fixed in 2.2.).
> >
> > The status bar shows Embedded database, HSQL database engine
> >
> > "Edit / Database / Advanced Settings" is shaded and isn't selectable.
>
> okay, that's intended, since those settings do not make much sense for
> embedded HSQL.
>
> > Is there another way I can get to "Edit / Database / Advanced Settings /
> > Special Settings" dialog or troubleshoot possible conflicting HSQLDB versions?
>
> To verify whether your OOo uses the shipped version of HSQLDB, or
> conflicts with another version in your system, see
> http://wiki.services.openoffice.org/wiki/HSQLDB:Tips_and_Tricks#How_to_know_the_version_of_the_embedded_HSQLDB.3F
> for how to obtain the version. You should get 1.8.0 resp. 1.8.0.4 or
> 1.8.0.<some 4 digits>. Everything below means there's another HSQLDB
> installation in your system, which is probably pointed to in your
> CLASSPATH environment variable, and thus used by OOo. In this case, try
> removing it from your CLASSPATH before starting OOo.
>
> Ciao
> Frank
>

I copied the code into a macro and hit run basic and I get a
NoSuchElelmentException error on
databaseDocument = databaseContext.getByName( databaseURLOrRegisteredName )

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

Fedora Core 6 includes hsqldb 1.8.0.4 and openoffice.org-core 2.0.4 (the
openoffice.org-core rpm lists hsqldb as a dependancy)

--
Brian Johnson, P. Eng
Johnson Engineering Consultants
http://johnson-engineering.ca
Ontario, Canada