SQL Update isn't working, not sure how to fix it.
-
This is the error I get when I try to update. ****************************************************************************** The query processor could not produce a query plan from the optimizer because a query cannot update a text, ntext, or image column and a clustering key at the same time. ****************************************************************************** Sample code that causes this error. private void button1_Click(object sender, EventArgs e) { this.Validate(); this.tb.EndEdit(); this.tb.Update(this.DataSet.tb); } Form was created by using the drag and drop abilities of the data source. simple form, only 4 items in the table.
-
This is the error I get when I try to update. ****************************************************************************** The query processor could not produce a query plan from the optimizer because a query cannot update a text, ntext, or image column and a clustering key at the same time. ****************************************************************************** Sample code that causes this error. private void button1_Click(object sender, EventArgs e) { this.Validate(); this.tb.EndEdit(); this.tb.Update(this.DataSet.tb); } Form was created by using the drag and drop abilities of the data source. simple form, only 4 items in the table.
Has anyone ever seen this? Or am I the winner of finding new ways to break code for the day? :->