Hello, 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' " The column "Name2" exists. Also if I rename it to "ZName" then the error messages contain this word "ZName". This is the Query which should be executed: sSelect = "SELECT `Firmennamen`, `Vorname`, `Nachname`, `ZName`, `Strasse`, `PLZ`, `Ort`, `Land`, `Postfach`, `Anrede`, `BriefAnrede`, `Anlagedatum`, `Aenderungsdatum`, `TelefonBeruflich`, `Faxnummer`, `TelefonPrivat`, `DurchwahlBuero`, `MobilesTelefon`, `EMailAdresse`, `Bankname`,`BLZ`, `Kontonummer`, `Geburtsdatum`, `EhepartnerName`,`Umsatzsteuerberechnung`, `Anmerkungen`,`Zeichen`,`Feld1` FROM `Adressen` WHERE `Adressen`.`ID` = '"+iAdressenID+"'" How can I solve it. For people, who don't unterstand the query. It is a Query about an address table. Regards Mechtilde -- Dipl. Ing. Mechtilde Stehmann ## Observer OpenOffice.org: lang/DE ## Freie Office-Suite für Linux, Mac, Windows, Solaris ## http://de.openoffice.org ## Meine Seite http://www.mechtilde.de ## PGP encryption welcome! Key-ID: 0x53B3892B --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
