Article ID: 175245 - Last Review: May 2, 2006 - Revision: 3.1

PRB: Unable to Update Long Text Fields Using ADO

View products that this article applies to.

System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.

This article was previously published under Q175245

Expand all | Collapse all

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

Back to the top

CAUSE

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

Back to the top

RESOLUTION

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

Back to the top

STATUS

This behavior is by design.

Back to the top

MORE INFORMATION

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.

Back to the top

REFERENCES

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:

http://support.microsoft.com/search/default.aspx?qu=vinterdev (http://support.microsoft.com/search/default.aspx?qu=vinterdev)

Back to the top