david-h
Posts: 29
|
| Posted: 03/31/2009, 9:39 AM |
|
Hello All
CSS 3.2.0.6
ASP3 Templates
MSSQL
Win 2003 server
Can anyone help with a strange problem?
I have an editable grid which works fine for search, add, delete etc.
But when I try to update, I get this error:
[Microsoft][ODBC SQL Server Driver][SQL Server]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. (Microsoft OLE DB Provider for ODBC Drivers)
Anyone know what this means - I'm not used to Windows quirks?!
Come back PHP & MySQL all's forgiven!!! 
Kind regards
David
|
 |
 |
peterr
Posts: 5971
|
| Posted: 03/31/2009, 11:04 AM |
|
Google:
http://weblogs.asp.net/sbehera/archive/2005/08/18/422971.aspx
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
david-h
Posts: 29
|
| Posted: 04/01/2009, 3:42 AM |
|
Hello Peter
Bingo! I searched Google most of yesterday afternoon for some info - thanks very much for your help.
Took all of two minutes to get it sorted out, updating beatifully now. 
Kind regards
David
|
|
|
|
|
