Microsoft KB Archive/163031

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

Article ID: 163031

Article Last Modified on 12/3/2003

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0 Standard Edition
 * Microsoft Visual FoxPro 3.0b Standard Edition
 * Microsoft Visual FoxPro 5.0 Standard Edition
 * Microsoft Visual FoxPro 6.0 Professional Edition
 * Microsoft Data Access Components 2.5

-



This article was previously published under Q163031



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
This behavior is by design.



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.

