oledb: foxpro index file not updating after inserts and updates
Hi Mike,
IDX files are an older style FoxPro index and as you've noticed, they don't
update by themselves. The newer compound index files (CDX) update by
themselves. You can have IDX files and a CDX file on the same table and they
will happily coexist.
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
http://msdn.microsoft.com/vfoxpro http://foxcentral.net
Quote:
> Hi,
> I have a fox pro database that I am using Ado via the foxpro oledb driver
> to
> update and insert data. The
> ".idx" index file doesn't seem to update by itself. How can I associate
> the
> index files to the connection.. The driver is Microsoft? Visual FoxPro?
> OLE
> DB Provider version 7.0.0.9465.
> Any help greatly appreciated...
> Mike
