FIX: Update Error When Updating Sybase Table from ASP

 Last reviewed: December 18, 1997
Article ID: Q168270
The information in this article applies to:
  • Microsoft Visual InterDev, version 1.0

SYMPTOMS

The following error occurs when updating a Sybase table from an Active Server Page that uses either a Data Command or Data Range Header Design- Time Control (DTC): 

   "The query is not updatable because the from clause is not a single
   simple table name. This may be caused by an attempt to update a non-
   primary table in a view."

CAUSE

The Data Command Control and the Data Range Header Control generate spaces before and after the table name. Because Sybase does not have a delimiter, referencing the table with the added spaces will fail when performing updates.

STATUS

Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article. This bug has been corrected in Visual Studio 97 Service Pack 1.

For additional information about the Visual Studio 97 Service Pack 1, please see the following article in the Microsoft Knowledge Base: 

   ARTICLE-ID: Q170365
   TITLE     : INFO: Visual Studio 97 Service Packs - What, Where, and Why

MORE INFORMATION

Steps to Reproduce Behavior

  1. In a Web project, insert a data connection to Sybase database.

  2. Create a new Active Server Page (.asp).

  3. Insert a Data Command Control DTC.

  4. Choose the Sybase connection in the "Data Connection" drop-down list of the Control's property sheet.

  5. Select "Table" from the "Command Type" drop-down list.

  6. Select a table from the "Command Text" drop-down list.

Results: The table name will display in the "Command Text" drop-down list as: 

   dbo. tablename
There is a space before and after the table name. The DTC will generate references to the table with the spaces, thus causing the Update errors. 
Keywords          : VS97FixlistSP3 kb3rdparty kberrmsg VS97FixlistSP2 VS97FixlistSP1
Version           : 1.0
Platform          : WINDOWS
Issue type        : kbbug
Solution Type     : kbfix kbservicepack

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

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 18, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.