Hello,I use OpenOffice 2.4 till 2 ou 3 days and have now the following problem regarding the use of database.
See the example I join here (database.odt). The situation : I use an external database (Oracle) as ODBC. The connection's name is orcl. On the example you see the original SQL (as it worked till OO 2.3).Below you see the SQL as is as been automatically changed by OO 2.4. In reality I didn't make any changes but only cliked on "modify" and rewrote the SQL with an another name.
The previous SQL leaves perfectly but the "new one" comes to the error :
Impossible de charger le contenu des données. Statut SQL: HY000 Code d'erreur: 933[Oracle][ODBC][Ora]ORA-00933: La commande SQL ne se termine pas correctementLa commande SQL suivante est à la source de l'erreur :SELECT DISTINCT "CONTACT"."EMAIL" FROM "ICAMP"."CONTACT" AS "CONTACT", "ICAMP"."PARTICIPANT" AS "PARTICIPANT" WHERE "CONTACT"."NO_CONTACT" = "PARTICIPANT"."NO_CONTACT" AND "PARTICIPANT"."ANNEE_ACTIVITE" = ? AND "PARTICIPANT"."NO_ACTIVITE" = ? AND "PARTICIPANT"."STATUS" <> 'A'
The problem comes from the new formulation "From "icamp"."contact" *AS "CONTACT"
*In the past I sent you already a problem regarding database but I don't know where my password should be ... Sorry.
With best regards, -- Raymond Gloor Directeur administratif Ligue Lecture Bible Ch. Bérée 70 CH-1010 Lausanne Tél. : +41 21 651.20.17 Fax : +41 21 651.20.19 courriel : [EMAIL PROTECTED] http://www.ligue.ch
database.odt
Description: application/vnd.oasis.opendocument.text
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
