Hi Mechtilde,

> We are trying to develope an Application based on MySQL and
> OpenOffice.org with StarBasic.
> 
> With OOo version 2.2.1 all things works well. As via ODBC as via JDBC.
> With OOo version 2.3.1 it only works with ODBC.
> As the developer versions of OOH as of SRC680/DEV300 it doesn't work.
> 
> The Error message is:
> with ODBC: "Basic-Laufzeitfehler. Es ist eine Exception aufgetreten.
> Type: com.sun.star.sdbc.SQLExeption. Message: [MySQL][ODBC 3.51
> Driver][mysqld-5.0.32-Debian_7etch4-log] Unknown column 'Name2' in
> 'field list' "
> 
> with JDBC: "Basic-Laufzeitfehler. Es ist eine Exception aufgetreten.
> Type: com.sun.star.sdbc.SQLExeption. Message: Unknown column 'Name2' in
> 'field list' "

This sounds like some problem in OOo's parser, as it happens with both
ODBC and JDBC.

For one, you can (as a workaround) try setting the EscapeProcessing
propery of the Statement object to FALSE, which will circumvent the
parser. Of course you'll need some functionality then, so this
workaround might not be reasonable.

Second, an interesting question would be whether this query works in the
query designer.

And finally, in every case I'd like to ask you to submit an issue - use
 mysqldump to create a dump of the structure (--no-data switch) of the
table, attach this dump, and please also provide a small Basic macro
showing the problem.

Thanks & Ciao
Frank
-- 
- Frank Schönheit, Software Engineer         [EMAIL PROTECTED] -
- Sun Microsystems                      http://www.sun.com/staroffice -
- OpenOffice.org Base                       http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to