Hi Manuel, >>The error message you cited suggests that the Sybase JDBC driver does >>not allow to use so-called catalogs (storedb in the example) in SELECT >>statements. Normally, the driver should tell OOo that it doesn't. Now >>either it does not properly tell, or OOo does not respect this. > > The JDBC Driver does allow catalogs, but only without quotes.
Ehm - how this? I mean, the quoting character is for exactly this: quoting identifiers in SQL statements. How can the driver not support such a basic thing? Sure it's really this? You mentioned that "select * from dbo.products". I am pretty sure that OOo will touch this statement, too, and make a (1) SELECT * FROM "dbo"."products" out of it. Can you try (1) - including the quotes - in "Run SQL direct" mode, and see whether this succeeds? I'd still assume that the catalog name is what the database/driver confuses, not the quotes. Quotes are way too basic to not be accepted, IMO. > The macro output just a box with the text true. Okay, we can interpret this when you tried the above statement :) > Yes I know that, but when I am saving the query. When I try to > generate a report openoffice complains that it can figure out all > table names and I would also that the driver just works. Argh, yes, there's an issue that the report wizard cannot work with native queries. The good news is that with some implementations currently done in a adjacent area (issue 51143), this limitation will be automatically be gone, so there's hope for 2.0.4 :) 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]
