SQL insert query does not execute

ERROR : La sous-requête a retourné plusieurs valeurs. Cela n'est pas autorisé quand la sous-requête suit =, !=, <, <= , >, >= ou quand elle est utilisée en tant qu'expression.

L'instruction a été arrêtée.

voici la requete

Program.cmd.CommandText = "insert into bon_reception_marche (Id_marche,Designation_bon_reception,Num_bon_reception,Date_reception,Unite,Qte,Prix_unitaire,Montant,TVA,MO,OT,User_create,Date_create)values((select distinct Id_marche from marche where Libelle_marche = '" + comboBox3.Text + "'),'" + textBox2.Text + "','" + textBox1.Text + "','" + dateTimePicker1.Value.Date + "','" + textBox3.Text + "', " + Convert.ToDouble(textBox4.Text) + "," + Convert.ToDouble(textBox5.Text) + "," + Convert.ToDouble(textBox6.Text) + "," + Convert.ToDouble(comboBox1.Text) + ",'" + textBox8.Text + "','" + textBox9.Text + "','" + values.username + "','" + DateTime.Now.Date + "')";

thanks for adavance

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bryian Tan9y ago
Accepted answer
As-tu essayé "select TOP 1 Id_marche from marche where ..."
ma ouml9y ago
oui je viens de l'essayer merci beaucoup :)
ma ouml9y ago
Here is my request
Bryian Tan9y ago
Very likely "select distinct Id_marche from marche" return more than one record.

Change it to "select TOP 1 Id_marche from marche" to see how it goes. Then investigate why the Select query return more than one record.