PRB: Index Deleted After Its Column Is Cut\Pasted Into Same Tbl

 Last reviewed: December 11, 1997
Article ID: Q175799
The information in this article applies to:
  • Microsoft Visual InterDev, version 1.0
  • Microsoft Visual Database Tools, version 1.0

SYMPTOMS

When you cut and paste a table field, which has an index, in the Schema Designer, the index is not re-created with the field.

RESOLUTION

Re-create the indexes and relationships when re-ordering fields in a table.

STATUS

This behavior is by design.

MORE INFORMATION

Steps to Reproduce Behavior

Use the following steps in the Schema Designer:

  1. Open a table -- in design mode -- that has an index on one of the fields.

  2. Open the Property page for the table.

  3. Pin the Property page for ease of viewing the behavior.

  4. Click the Index/Keys tab.

  5. To better see the problem, select an index from the list. When you cut the field from the table, you will see the index disappear from the list.

  6. Highlight the associated field in the Table Designer.

  7. Cut the column using the CTRL+X keys.

  8. Paste the column in a different field position than from where it came from using the CTRL+V keys.

In the Property page, notice that the associated index is gone and was not replaced when the field was pasted back into the table definition.

REFERENCES

For the latest Knowledge Base articles and other support information on Visual InterDev and Active Server Pages, see the following page on the Microsoft Technical Support site: 

   http://support.microsoft.com/support/vinterdev/


Keywords          : kbDtDbDesigner
Technology        : kbInetDev
Version           : WINDOWS:1.0
Platform          : WINDOWS
Issue type        : kbprb

================================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: December 11, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.