FIX: If You Create a Table With Query Analyzer from Visual InterDev then the SQL Enterprise Manager Inserts the Incorrect Decimal (9, 0) Values (260092)



The information in this article applies to:

  • Microsoft Visual Studio, Enterprise Edition 6.0
  • Microsoft Visual Studio 6.0 SP1
  • Microsoft Visual InterDev 6.0

This article was previously published under Q260092

SYMPTOMS

When you type "123456789" in the SQL Enterprise Manager (SEM) and then choose to Return all rows from a table in Query Analyzer, the numbers that you entered are automatically changed to "123456800."

CAUSE

This problem is a result of the DaVinci bug in Visual Studio 6.0.

RESOLUTION

To resolve this problem, install the latest service pack for Visual Studio 6.0.

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article. This bug was corrected in the latest service pack for Visual Studio 6.0.

For additional information about Visual Studio service packs, click the following article numbers to view the articles in the Microsoft Knowledge Base:

194022 INFO: Visual Studio 6.0 Service Packs, What, Where, Why

194295 HOWTO: Tell That a Visual Studio Service Pack Is Installed

To download the latest Visual Studio service pack, visit the following Microsoft Web site:

MORE INFORMATION

Steps to Reproduce Behavior

NOTE: To reproduce the behavior, you must understand how to create database connections and database design. If you need additional information, please see the MSDN Library documentation.

Perform the following steps on a computer running both Visual InterDev and Visual Studio Service 6.0 Pack 3 or earlier:
  1. In Query Analyzer, right-click the Tables folder, select Create new table, and then type "create table test(col1 decimal(9,0)."
  2. Open SEM (SQL Enterprise Manager), and then drill down to the table that you created in Query Analyzer.
  3. Right-click the table that you created, and then click Return all rows.
  4. Type "123456789," and then press ENTER. These digits change to "123456800."

REFERENCES


Modification Type:MinorLast Reviewed:12/12/2005
Keywords:kbBug kbfix kbVS600sp4fix kbVS600sp5fix KB260092