BUG: Copy SQL Script Does Not Work Correctly from Visual InterDev If Table Has More Than 256 Fields (294065)


The information in this article applies to:

  • Microsoft Visual InterDev 6.0
This article was previously published under Q294065

SYMPTOMS

If you use the Copy SQL Script option from the Data View window in Visual InterDev on a table that has more than 256 fields, the order of the fields is re-arranged, and only the last 256 fields are copied.

RESOLUTION

Use the following workaround to copy the script to create the table from within the Visual InterDev integrated development environment (IDE):
  1. Open the table that has more than 256 fields in design view. To do this, right-click the table in the Data View window, and then click Design from the Context menu.
  2. Insert a column at the top of the table. You must name the column so that the change is recognized.
  3. On the table toolbar, click Save Change Script.
  4. In the Save Change Script dialog box, click Yes to save the changed script. A message box indicates where the change script is saved.
  5. Browse to the file location, open the file, and modify the script so that the script creates the table without the new column.

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.
Modification Type:MajorLast Reviewed:4/6/2001
Keywords:kbbug kbide KB294065
©2002 Microsoft Corporation. All rights reserved.