PRB: Unable to Update Long Text Fields Using ADOLast reviewed: December 11, 1997Article ID: Q175245 |
The information in this article applies to:
SYMPTOMSWhen 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 CAUSEActiveX Data Objects (ADO) 1.0 does not support updating long text fields with a forward-only cursor.
RESOLUTIONUse a cursor that supports bookmarks (for example, Keyset or Static).
STATUSThis behavior is by design.
MORE INFORMATIONIf you have used Visual InterDev's DataForm Wizard to create the code that is experiencing this problem, follow these instructions:
REFERENCESFor 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 |
================================================================================
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |