 | Start a set with this search |
 | Include this search in one of my sets |
 | Exclude this search from one of my sets |
 | Permalink to these results Paste this link in email or IM: |
 | Atom feed for tracking future search results Paste this URL into your reader: |
4 messages in org.openoffice.fr.progRE: [prog] [MTSQL-ODBC] Erreur à la m...| From | Sent On | Attachments |
|---|---|---|
| jeannelle-d | Aug 6, 2004 2:35 am | |
| Alex Thurgood | Aug 6, 2004 5:24 am | |
| jeannelle-d | Aug 6, 2004 6:23 am | |
| jeannelle-d | Aug 6, 2004 7:02 am |
| Permalink for this message Paste this link in email or IM: |
| Permalink for this thread Paste this link in email or IM: |
| Atom feed for this thread Paste this URL into your reader: |
| Subject: | RE: [prog] [MTSQL-ODBC] Erreur à la mise à jour d'enregistrements | Actions... |
|---|---|---|
| From: | jeannelle-d (jean...@chu-caen.fr) | |
| Date: | Aug 6, 2004 7:02:29 am | |
| List: | org.openoffice.fr.prog | |
Impeccable !!!!
ça fait des semaines que l'on a buté là-dessus avec les stagiaires ... et visiblement, ça semble OK après la manip indiquée dans le post en question. Ca semble quand même un bug de la liaison OOo <--> MySQL, parce que, effectivement, en accès direct (MySQLFront par exemple) ou en programmation macro dans OOo, aucun souci.
En tous cas, mille merci, voilà une sacrée épine du pied retirée.
Denis (j'ai encore une dernière question, mais, selon les bons conseils de Sophie, je fais un autre post !!! ;-))
__________________________________ Direction du Système d'Information Denis JEANNELLE - adjoint au DSI
CHU CAEN - avenue Clemenceau - 14 033 Caen Cedex
Tél : 02.31.27.26.53
-----Message d'origine----- De : Alex Thurgood [mailto:alex...@free.fr] Envoyé : vendredi 6 août 2004 14:25 À : pr...@fr.openoffice.org Objet : Re: [prog] [MTSQL-ODBC] Erreur à la mise à jour d'enregistrements
Le ven 06/08/2004 à 11:36, jeannelle-d a écrit :
Bonjour,
Trouvé sur http://www.oooforum.org/forum/viewtopic.php?t=5059
Une idée ???? Je suis sous WinXP Pro, mais j'ai déjà eu ce pb sous Win98.
______________________________________________________________ __________ Without understanding why, I have isolated what causes OOo to cause the SQLBindParameter error. It is caused by having a UNIQUE KEY in a table in an INNODB database. The error doesn't happen all the time, but most of the time. Sometimes also in Writer, too. Removing the line: "UNIQUE KEY title (title)," from the table definition 'fixes' it. Unfortunately I need two columns to be unique so this isn't helpful. I have worked round this by removing the PRIMARY KEY from an auto_increment column, and just un-enabling that field on my forms, and putting the PRIMARY KEY on the previously UNIQUE KEY column. This doesn't stop the supposedly unique number column from getting updated directly, however.
Has anyone else experienced problems with UNIQUE KEYS and OOo and is there any proper fix for it?
Et la suite :
I've experienced the same problem myself. I just discovered the source as the UNIQUE key index today.
I've had the same trouble while trying to use forms, but oddly enough only after I do a refresh of the datasource connection. Prior to that I can edit away to my heart's content. One refresh and I get the "SQLBindParameter not used for all parameters" error.
Voilà ce que j'ai trouvé pour l'instant.
Alex