G
Guest
I am using the SQL Data Adapter update command to update data in a SQL 2000
table. I am receiving the following error on the save.
"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."
The SQL table has one primary key and has a field with "text" data type.
This table also has cascade updates and deletes on child tables. The strange
thing is that this worked at one time; and nothing has changed as far as
fields and cascades go.
Using the SQL Data Adapter, I am able to update other tables that have text
data type and cascade deletes and updates.
What can cause this error?
Thanks.
table. I am receiving the following error on the save.
"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."
The SQL table has one primary key and has a field with "text" data type.
This table also has cascade updates and deletes on child tables. The strange
thing is that this worked at one time; and nothing has changed as far as
fields and cascades go.
Using the SQL Data Adapter, I am able to update other tables that have text
data type and cascade deletes and updates.
What can cause this error?
Thanks.