csharpdoost
پنج شنبه 08 تیر 1396, 18:50 عصر
با سلام
با کد زیر میخوام چند رکورد رو همزمان بروزرسانی کنم اما خطا میده:
try {
OleDbConnection conc = new OleDbConnection(ConnectionString);
OleDbCommand com = new OleDbCommand();
com.Connection = conc;
com.CommandText = "update kala set resetKHaridCust= " + true + " where (select * from kala where codemelliPresenter= " + textBox10.Text.Trim() + ")";
conc.Open();
com.ExecuteNonQuery();
conc.Close();
و پیغام خطا :
You have written a subquery that can return more than one field without using the EXISTS reserved word in the main query's FROM clause. Revise the SELECT statement of the subquery to request only one field.
با کد زیر میخوام چند رکورد رو همزمان بروزرسانی کنم اما خطا میده:
try {
OleDbConnection conc = new OleDbConnection(ConnectionString);
OleDbCommand com = new OleDbCommand();
com.Connection = conc;
com.CommandText = "update kala set resetKHaridCust= " + true + " where (select * from kala where codemelliPresenter= " + textBox10.Text.Trim() + ")";
conc.Open();
com.ExecuteNonQuery();
conc.Close();
و پیغام خطا :
You have written a subquery that can return more than one field without using the EXISTS reserved word in the main query's FROM clause. Revise the SELECT statement of the subquery to request only one field.