Solved

Unable to Update Long Text Fields Using ADO

Posted on 1997-11-21
3
358 Views
Last Modified: 2010-05-18
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:
  (http://premium.microsoft.com/support/kb/articles/q175/2/45.asp)

       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

       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.




0
Comment
Question by:weinerk
  • 2
3 Comments
 
LVL 2

Accepted Solution

by:
Wiz_of_Oz earned 20 total points
ID: 1089279
maybe you opened your cursor in forward mode, check in the source code the CursorType and the Lock Properties...

to insert/update a record these properties have to be at least set to:
adOpenStatic ---------  3
adLockOptimistic ----- 3

for more info append the code of your asp where the connection and the cursor are opened.
0
 
LVL 1

Author Comment

by:weinerk
ID: 1089280
I also updated to MDAC 1.5

so i am not sure what did it

also was wondering where can i get more info of cusors and locks?
thanks

0
 
LVL 2

Expert Comment

by:Wiz_of_Oz
ID: 1089281
I evaluated the idea to update to MSDAC but i preferred to continue using ADO for his semplicity...
for more info about cursors and locks in ADO look at the on-line documentation in Visual Interdev..
it's very simple and explicative...
let me know how your work go
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Introduced in Microsoft SQL Server 2005, the Copy Database Wizard (http://msdn.microsoft.com/en-us/library/ms188664.aspx) is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now