Raymond Gloor wrote:
Hello,
I use OpenOffice 2.4 till 2 ou 3 days and have now the following
problem regarding the use of database.
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
correctement
La 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"
*
Hello Raymond,
Something to try -
Open the ODB file - and before you connect ( don't open a form or click
on tables ) select
Edition > Base de donnes > Parametres avances ( In English Edit >
Database > Advanced Settings ) sorry I know I don't have the actual
characters in the French.
The first option on this dialog should be "Ajouter le nom d'alias de la
table aux instruction SELECT" - turn this off.
That should take care of it.
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
