Microsoft KB Archive/175245

= PRB: Unable to Update Long Text Fields Using ADO =

Article ID: 175245

Article Last Modified on 5/2/2006

-

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

-



This article was previously published under Q175245



SYMPTOMS
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



CAUSE
ActiveX Data Objects (ADO) 1.0 does not support updating long text fields with a forward-only cursor.



RESOLUTION
Use a cursor that supports bookmarks (for example, Keyset or Static).



STATUS
This behavior is by design.



MORE INFORMATION
If you have used Visual InterDev's DataForm Wizard to create the code that is experiencing this problem, follow these instructions:
 * 1) Edit xxxForm.asp.
 * 2) Search for the text: "DesignerControl" startspan.
 * 3) Right-click any of the text that is displayed in green, and select "Edit Design-time Control..."
 * 4) Click the Advanced tab.
 * 5) Change the "Cursor Type" to one that supports bookmarks (for example, 3- Static).
 * 6) Save the changes.
 * 7) Edit xxxList.asp and perform steps 2-6 again.

