Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 175245 - Last Review: May 2, 2006 - Revision: 3.1
PRB: Unable to Update Long Text Fields Using ADO
This article was previously published under Q175245
When attempting to perform a table update, the following message appears:
Query Based Insertion or Updating of BLOB values can not be supported.
This may be caused by an attempt to update a non-primary table in a
view
ActiveX Data Objects (ADO) 1.0 does not support updating long text fields
with a forward-only cursor.
Use a cursor that supports bookmarks (for example, Keyset or Static).
This behavior is by design.
If you have used Visual InterDev's DataForm Wizard to create the code that
is experiencing this problem, follow these instructions:
- Edit xxxForm.asp.
- Search for the text: "DesignerControl" startspan.
- Right-click any of the text that is displayed in green, and select
"Edit Design-time Control..."
- Click the Advanced tab.
- Change the "Cursor Type" to one that supports bookmarks (for example, 3-
Static).
- Save the changes.
- Edit xxxList.asp and perform steps 2-6 again.
For the latest Knowledge Base articles and other support information on
Visual InterDev and Active Server Pages, see the following page on the
Microsoft Technical Support site:
APPLIES TO
- Microsoft Visual InterDev 1.0 Standard Edition
- Microsoft Active Server Pages 4.0
- Microsoft Visual Studio 97 Service Pack 3
- Microsoft ActiveX Data Objects 1.0
- Microsoft ActiveX Data Objects 1.5
- Microsoft ActiveX Data Objects 2.0
- Microsoft ActiveX Data Objects 2.1 Service Pack 2
- Microsoft ActiveX Data Objects 2.5
- Microsoft ActiveX Data Objects 2.6
| kberrmsg kbmdacnosweep kbprb kbwizard KB175245 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate