Re: Problem with subforms in 2.0.4 in Fedora Core 6

Frank Sch�nheit - Sun Microsystems Germa ny ([email protected])
wrote:
>
> Hi Brian,
>
> > When I try to make a subform, no matter what I do, I end up getting an error
> > "unepected token: : in statement ... "
> >
> > When I click on more in the error dialog box I get:
> > SQL Status: 37000
> > Error code: -11
> >
> > Unexpected token: : in statement [SELECT * FROM "watches" WHERE ( "brand" =
> > :link_from_brand )]
>
> Don't know which database you use ...
>
> 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.).
>
> If you use another database, you might want to try the "Replace named
> parameters with '?'" option in the "Edit / Database / Advanced Settings
> / Special Settings" dialog.
>
> Ciao
> Frank
>

Thanks for your advice Frank.

The status bar shows Embedded database, HSQL database engine

"Edit / Database / Advanced Settings" is shaded and isn't selectable.

Is there another way I can get to "Edit / Database / Advanced Settings /
Special Settings" dialog or troubleshoot possible conflicting HSQLDB versions?