Subject: Re: Strange duplicate key problem - msg#00126

Previous Message by Date: click to view message preview

RE: Strange duplicate key problem

Really thanks, I'm really stupid these days ! ism > -----Message d'origine----- > De : Arno Bouwman [mailto:info@xxxxxxxxxx] > Envoyé : jeudi 17 octobre 2002 15:26 > À : Ismael Touama > Objet : Re: Strange duplicate key problem > > > Hello, > > Try this: > INSERT INTO article_connexe (Ref_art, Ref_cnx) > VALUES ('w1', 'w2') > > Arno. > ----- Original Message ----- > From: "Ismael Touama" <ismael.touama@xxxxxxxxxx> > To: <win32@xxxxxxxxxxxxxxx> > Sent: Thursday, October 17, 2002 3:14 PM > Subject: Strange duplicate key problem > > > > Hello all, > > > > I 'm front of a strange trouble. > > My table (connexe) is 2 fields varchar(20). > > These 2 fields are composing a Primary Key. > > (ref_art and ref_cnx) > > > > When I'm doing this query: > > INSERT INTO article_connexe (Ref_art, Ref_cnx) > > VALUES (Ref_art = 'w1', Ref_cnx = 'w2') > > > > It's inserting me 0-0 !!! > > I don't understand where the errors occur. > > > > Someone can help ? > > > > Thank you, > > ism > > > > --------------------------------------------------------------------- > > Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before > posting. To request this thread, e-mail win32-thread9958@xxxxxxxxxxxxxxx > > To unsubscribe, send a message to the address shown in the > List-Unsubscribe header of this message. If you cannot see it, > e-mail win32-unsubscribe@xxxxxxxxxxxxxxx instead. > --------------------------------------------------------------------- Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail win32-thread9960@xxxxxxxxxxxxxxx To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail win32-unsubscribe@xxxxxxxxxxxxxxx instead.

Next Message by Date: click to view message preview

RE: mysql_thread_init(), mysql_thread_end()

Hi, yes, you have to recompile the library. I can't tell you which flags to set. I only remember that the default configuration does not support these functions. Erich hello, 'just migrating from ODBC to Mysql-API: the functions mysql_thread_init(), mysql_thread_end() are not defined in the windows version of mysql api. do i have to recompile the lib with some additional flags? mysql_thread_safe() returns true. or am i doing something wrong here? armin. --------------------------------------------------------------------- Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail win32-thread9962@xxxxxxxxxxxxxxx To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail win32-unsubscribe@xxxxxxxxxxxxxxx instead.

Previous Message by Thread: click to view message preview

Strange duplicate key problem

Hello all, I 'm front of a strange trouble. My table (connexe) is 2 fields varchar(20). These 2 fields are composing a Primary Key. (ref_art and ref_cnx) When I'm doing this query: INSERT INTO article_connexe (Ref_art, Ref_cnx) VALUES (Ref_art = 'w1', Ref_cnx = 'w2') It's inserting me 0-0 !!! I don't understand where the errors occur. Someone can help ? Thank you, ism --------------------------------------------------------------------- Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail win32-thread9958@xxxxxxxxxxxxxxx To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail win32-unsubscribe@xxxxxxxxxxxxxxx instead.

Next Message by Thread: click to view message preview

Re: Strange duplicate key problem

try this: INSERT INTO article_connexe (Ref_art, Ref_cnx) VALUES ('w1', 'w2') you've already specified the columns. ----- Original Message ----- From: "Ismael Touama" <ismael.touama@xxxxxxxxxx> To: <win32@xxxxxxxxxxxxxxx> Sent: Thursday, October 17, 2002 9:14 PM Subject: Strange duplicate key problem Hello all, I 'm front of a strange trouble. My table (connexe) is 2 fields varchar(20). These 2 fields are composing a Primary Key. (ref_art and ref_cnx) When I'm doing this query: INSERT INTO article_connexe (Ref_art, Ref_cnx) VALUES (Ref_art = 'w1', Ref_cnx = 'w2') It's inserting me 0-0 !!! I don't understand where the errors occur. Someone can help ? Thank you, ism --------------------------------------------------------------------- Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail win32-thread9958@xxxxxxxxxxxxxxx To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail win32-unsubscribe@xxxxxxxxxxxxxxx instead. --------------------------------------------------------------------- Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail win32-thread9967@xxxxxxxxxxxxxxx To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail win32-unsubscribe@xxxxxxxxxxxxxxx instead.