using Microsoft Visual InterDev, version 1.0
using data form wizard created a asp form that accesses odbc DB (MS SQL)
runing into a problem with updating fields of type text
supposebly because ActiveX Data Objects (ADO) 1.0
does not support updating long text fields with a forward-only cursor.
tried remedy suggested by microsoft (see below)
did not work any clues ?
according to microsoft:
PRB: Unable to Update Long Text Fields Using ADO
Last reviewed: October 20, 1997
Article ID: Q175245
The information in this article applies to:
Microsoft Visual InterDev, version 1.0
Microsoft Active Server Pages, versions 1.0, 1.0b
Microsoft Visual Studio 97
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
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:
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.