[SLE] Open Office Database Wizard Question
From: Greg Wallace (jgregw_at_acsalaska.net)
To: <firstname.lastname@example.org> Date: Fri, 30 Sep 2005 20:49:58 -0800
I'm trying to run an OpenOffice database query against an Oracle database on
the same machine via an ODBC connection. I can see tables and build queries
in Open Office DB just fine, but when I try to run them, I get the following
(always the same, so this is a sample from one I ran) --
SQL STATUS: HY000
Error Code: 1000
Syntax error in SQL Expression
Syntax error, unexpected INVALIDSYMBOL, expecting FROM or SQL_TOKEN_INTO,
Invalid symbol: ."A"
The sql it put together in the Query Wizard looks like this --
SELECT "TEST_TABLE1"."A" FROM "OPS$GREGW"."TEST_TABLE1" "TEST_TABLE1"
Why it wants to put the "'s around everything I don't know, but I copied
this exact sql statement into the Oracle built in interactive tool
(sqlplus), ran it, and it worked fine. It's actually a perfectly valid
query (select table TEST_TABLE1 column A from
schema.table=OPS$GREGW.TEST_TABLE1" assigning an alias to the table of
TEST_TABLE1). Anybody have any clues on what could be going wrong here and
why OpenOffice can build but not run this query?
-- Check the headers for your unsubscription address For additional commands send e-mail to email@example.com Also check the archives at http://lists.suse.com Please read the FAQs: firstname.lastname@example.org