Help me about bindingsource
-
I have a table named STAFF contains fields like STAFFID, FULLNAME, BIRTHDAY, SEX, PHOTO. I use BindingSource to update database. Initially, when I have no PHOTO field, updating database is successful. After that, when I add PHOTO field into STAFF table, the failure of updating database is due to having a following error "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." I have searched all helps but no article mentions it. Please kindly help me solve this error. Thanks in advance.
It seem to be a solution or an answer.
-
I have a table named STAFF contains fields like STAFFID, FULLNAME, BIRTHDAY, SEX, PHOTO. I use BindingSource to update database. Initially, when I have no PHOTO field, updating database is successful. After that, when I add PHOTO field into STAFF table, the failure of updating database is due to having a following error "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." I have searched all helps but no article mentions it. Please kindly help me solve this error. Thanks in advance.
It seem to be a solution or an answer.
Maybe this helps: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=678123&SiteID=1[^]
-
I have a table named STAFF contains fields like STAFFID, FULLNAME, BIRTHDAY, SEX, PHOTO. I use BindingSource to update database. Initially, when I have no PHOTO field, updating database is successful. After that, when I add PHOTO field into STAFF table, the failure of updating database is due to having a following error "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." I have searched all helps but no article mentions it. Please kindly help me solve this error. Thanks in advance.
It seem to be a solution or an answer.
-
I have a table named STAFF contains fields like STAFFID, FULLNAME, BIRTHDAY, SEX, PHOTO. I use BindingSource to update database. Initially, when I have no PHOTO field, updating database is successful. After that, when I add PHOTO field into STAFF table, the failure of updating database is due to having a following error "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." I have searched all helps but no article mentions it. Please kindly help me solve this error. Thanks in advance.
It seem to be a solution or an answer.