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
--
- 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]
