Re: Problem with subforms in 2.0.4 in Fedora Core 6

Frank Sch�nheit - Sun Microsystems Germa ny ([email protected])
wrote:
>
> Hi Brian,
>
> >>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.
>
> You certainly have an URL :), as that's the URL of the database file you
> opened.
> If your file is, say, in /foo/bar/database.odb, then the URL to enter in
> line 5 is file:///foo/bar/database.odb.

Thank your for your patience and help.  I've added the file URL using the
example you provided and the macro now runs without error and shows 1.8.0



> > When I'm just making queries and forms within the oo.org native database file
> > itself, do I still have to register it?
>
> No, no need to. registering only allows you to address databases with a
> fixed location by a short name.
>
> > I couldn't find much information about what registering really did or how to
> > do it in a current version.
>
> Tools/Options/OpenOffice.org Base/Databases.
>
> > 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"()]
>
> Which means you have a version < 1.8.0.5, which means OOo is using a
> version *not* shipped with OOo, but present somewhere else in your system.
> Did you try the CLASSPATH-thingie I mentioned in my previous mail?
>

Yes.  Judging from the rpms, I think it is 1.8.0.4

I had trouble understanding the CLASSPATH environment variable advice.  I did
echo $CLASSPATH in a bash shell (the konsole program in kde) and just a blank
line printed.



> Ciao
> Frank
>
> --
> - Frank Sch�nheit, Software Engineer         [email protected] -
> - Sun Microsystems                      http://www.sun.com/staroffice -
> - OpenOffice.org Database                   http://dba.openoffice.org -
> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
>