Microsoft KB Archive/168270

= FIX: Update Error When Updating Sybase Table from ASP =

Article ID: 168270

Article Last Modified on 4/22/2001

-

APPLIES TO


 * Microsoft Visual InterDev 1.0 Standard Edition

-



This article was previously published under Q168270



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:

170365 INFO: Visual Studio 97 Service Packs - What, Where, and Why



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: kberrmsg kbbug kbfix kbvs97sp1fix kbvs97sp2fix kbvisid600fix kb3rdparty KB168270

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.