I have mysql rev 4.1.12 running on win2000. A program, build with c++builder 6 and mdac, with several thread, each thread create it' own database connection and run it's own query. It's happen that sometimes I get an error for some query which are correct, if I retry it I run it sucessfully. The error reported seems to refer to some other query or error or are tampered with abnormal extra info. see the example belowe. I didn't understand what kind of problem I hav. Does someone experctise similar problem ?

Reagrds, Enzo Arlati

[19/10/2005 15.47.03] [NewMyQuery](line=228) (SQL=SELECT messaggio, operatore, priorita FROM stato_messaggi WHERE nome_nodo like 'P1302007' and codice_msg like '' ) ERRORE You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''W' at line 1

[20/10/2005 15.16.57] [NewMyQuery](line=228) (SQL= select max(data_prossimo_invio) max_data_prossimo_invio from coda_messaggi where nome_nodo = 'P1301002' and codice_msg = 'W1' and data_prossimo_invio < current_timestamp and ( data_prossimo_invio > data_ultimo_invio ) ) ERRORE You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE nome_nodo like 'P1302013' AND codice_msg like 'W1' AND inviato = 0data_p' at line 1