The information in this article applies to:
BUG#: 13762 (6.00) SYMPTOMS
Applications attempting to update a view through SQL Server server cursors
will receive the following error even if the operation observes the SQL
Server requirement that updates through views only update a single base
table:
WORKAROUNDOpen the cursor with a select against the base tables instead of the view. Alternatively, open a second connection and issue an SQL update command based on key values through the second connection. STATUSMicrosoft has confirmed this to be a problem in the Microsoft SQL Server version 6.00. This problem was corrected in SQL Server version 6.50. MORE INFORMATION
There are two types of applications that encounter this problem with server
cursors. Db-library applications can run into the problem if they have
opened a server cursor and attempt a dbcursor() command with the CRS_UPDATE
option. ODBC applications using the Microsoft SQL Server ODBC Driver can
encounter this when they have a server cursor open and attempt a
SQLSetPos() command with the SQL_UPDATE option.
Additional query words: default
Keywords : kbprg SSrvProg kbbug6.00 |
Last Reviewed: March 25, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |