Knowledge Base

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

MORE INFORMATION

Steps to Reproduce Behavior

In a Web project, insert a data connection to Sybase database.
Create a new Active Server Page (.asp).
Insert a Data Command Control DTC.
Choose the Sybase connection in the "Data Connection" drop-down list of the Control's property sheet.
Select "Table" from the "Command Type" drop-down list.
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

Microsoft KB Archive/168270

Contents