Re: Problem with subforms in 2.0.4 in Fedora Core 6

Frank Schönheit - Sun Microsystems Germa ny <[email protected]>
Newsgroups gmane.comp.openoffice.dba.user
Message-ID <[email protected]>
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

-- 
- Frank Schönheit, Software Engineer         [email protected] -
- Sun Microsystems                      http://www.sun.com/staroffice -
- OpenOffice.org Database                   http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.