PRB: Help of VFP ODBC Driver Unclear on INDEX ON Command

 Last reviewed: January 31, 1997
Article ID: Q163031
The information in this article applies to:
  • Microsoft Visual FoxPro for Windows, versions 3.0, 3.0b, 5.0

SYMPTOMS

The Visual FoxPro ODBC Driver Help File has conflicting information on the availability of the INDEX ON command.

RESOLUTION

The INDEX ON command is not supported in the Visual FoxPro ODBC driver. However, it is possible to create regular indexes on existing tables, through the ODBC driver, using the ALTER TABLE command. To do this create a persistent relation to the same table, or another, then break the relationship with the "DROP FOREIGN KEY" clause but use the SAVE clause to preserve the tag.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

Bring up the Visual FoxPro ODBC Help file by selecting ODBC from the Windows Start menu, and selecting "Visual FoxPro ODBC Driver," or by double- clicking the file Drvvfp.hlp in the Windows\System or Windows\System32 subdirectory. Go to Contents tab, click Technical References, then select "Language Support in Rules, Triggers, Default Values, and Stored Procedures." If you look at this list of commands and functions supported, INDEX is shown. However, if the hot link, located at the top of the page, is taken to the "Unsupported commands and functions," INDEX is listed AGAIN.

The INDEX ON command is not supported in the Visual FoxPro ODBC driver.

REFERENCES

For more information about removing Persistent Relationships, please see the following article(s) in the Microsoft Knowledge Base: 

   ARTICLE-ID: Q130352
   TITLE     : How To Remove Table from Persistent Relation with Program
For more information about creating Persistent Relationships, please see the following article(s) in the Microsoft Knowledge Base: 

   ARTICLE-ID: Q130243
   TITLE     : How To Create Persistent Relations Using ALTER TABLE SQL

KBCategory: kbinterop kbprb
KBSubcategory: FxinteropOdbc VFoxWin
Additional reference words: 3.00 3.00b 5.00 VFPODBC



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: January 31, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.