PRB: Unable to Update Long Text Fields Using ADO

Last reviewed: December 11, 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

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.

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/support/vinterdev/

Keywords          : VIADO VIWizards kberrmsg
Technology        : kbInetDev
Version           : WINDOWS:1.0; WINNT:1.0,1.0b,97
Platform          : WINDOWS winnt
Issue type        : kbprb


================================================================================


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: December 11, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.