Am Donnerstag, den 23.08.2007, 18:46 -0500 schrieb Barbara Duprey:
>
> Marc Santhoff wrote:
> > Am Donnerstag, den 23.08.2007, 16:42 -0500 schrieb Barbara Duprey:
> >
> >
> >> OK, I saw in the Help that only admin commands are allowed in the
> >> Execute SQL Statement dialog, so I created a query. Same result, except
> >> that the whole statement is there. So what token is it complaining about?
> >>
> >> SQL Status: 37000
> >> Error code: -11
> >>
> >> Unexpected token in statement [UPDATE "Addresses" SET "ADDR" = TRIM(
> >> "ADDR" )]
> >>
> >
> > A quick shot: did you try disabling the internal parsing of OO.o?
> >
> > It must be some button or menu named "parse statement" or the like
> > (cannot have a look atm).
> >
> > HTH,
> > Marc
> >
> >
> I couldn't find anything quite like that -- closest I could come was
> "Run SQL Directly" and that didn't complain but didn't do anything to my
> table, either. Searching on parse in help didn't find anything, and I
> didn't find anything that looked relevant in Issue Tracker.
That's the one. Normally this prevents OO.o from trying to parse
("understand") the statement (your SQL) before sending to the connected
database engine. And since it did without error at least the syntax
seems to be correct.
For the task of designing queries the only help I can give currently is
pointing you to:
www.hsqldb.org
The documentation link has what you need ...
Marc
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
