[SLE] Open Office Database Wizard Question

• Previous message: Toshi Esumi: "Re: [SLE] a two interfaces. SuSE 9.3"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

To: <suse-linux-e@suse.com>
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?

Thanks,
Greg Wallace

-- 
Check the headers for your unsubscription address
For additional commands send e-mail to suse-linux-e-help@suse.com
Also check the archives at http://lists.suse.com
Please read the FAQs: suse-linux-e-faq@suse.com

• Previous message: Toshi Esumi: "Re: [SLE] a two interfaces. SuSE 9.3"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]