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]
