Re: How do I add an index to a FoxPro table

From: Cindy Winegarden (cindy.winegarden_at_mvps.org)
Date: 03/30/04


Date: Tue, 30 Mar 2004 10:50:33 -0500

Hi Dave,

You can't. FoxPro's Index command is not supported by the OLE DB provider.
If you've got an MSDN subscription you can fire up VFP and create an index
on your table that way. In order to create an index you must have exclusive
use of the table.

-- 
Cindy Winegarden  MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden@mvps.org  www.cindywinegarden.com
"Dave" <anonymous@discussions.microsoft.com> wrote in message
news:967E37CC-A7DC-4BE7-9885-9EC2786F9A6F@microsoft.com...
> Hi
>
> Does anyone know how I can add an index to an existing FoxPro table using
ADO 2.8 from VB?
>
> Any assistance would be greatly appreciated.


Relevant Pages

  • Re: Fatal Error when using Free tables in VFP 9.0.beta
    ... If it's a network problem, whether it's a free table or in a .DBC will make ... >> Microsoft Visual FoxPro MVP ... >>> I am currently evaluating VFP 9.0 beta version. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Foxcode.dbf missing
    ... You're not sharing a FOXUSER configuration file between the different ... Microsoft Visual FoxPro MVP ... Next time you start VFP the location should be reused ... >>> Foxpro starts every session without active intellisense. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: RUNNING XXCOPY.EXE
    ... Microsoft Visual FoxPro MVP ... subfolders and then paste it to another folder like xcopy does. ... Here's one (the first one that comes up in Google with "VFP recursive ...
    (microsoft.public.fox.programmer.exchange)
  • Re: FoxFix 5.2 detecting memo corruption after COPY TO?
    ... but FoxFix v5.2 was released expressly for VFP8. ... We don't use the TYPE parameter since we are using plain old VFP tables. ... >> Memo Next Available Block invalid ... >> MCSD - Microsoft Visual FoxPro ...
    (microsoft.public.fox.vfp.dbc)
  • Re: FoxFix 5.2 detecting memo corruption after COPY TO?
    ... but FoxFix v5.2 was released expressly for VFP8. ... We don't use the TYPE parameter since we are using plain old VFP tables. ... >> Memo Next Available Block invalid ... >> MCSD - Microsoft Visual FoxPro ...
    (microsoft.public.fox.programmer.exchange)