Microsoft KB Archive/294065

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

Article ID: 294065

Article Last Modified on 4/6/2001

-

APPLIES TO


 * Microsoft Visual InterDev 6.0 Standard Edition

-



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.

Keywords: kbbug kbide kbpending KB294065

-

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

© Microsoft Corporation. All rights reserved.