Reindex a FoxPro Table by SQL command

I am using an ADO object to access a FoxPro table (DBF file).

The problem is when I insert new records in the table, the indexs of
the table are not reajusted. I expect that I must recreate or rebuild
the indexs but neither drop index and create index queries work.

Any advice??

P.S. If I can't post this kind of question in this news group please
tell me in witch news group I should post my question.

Thx

In news: i8ha80t22qirkir0467n3sq7j55f5lqd8a.DeleteThis@4ax.com,
François Reid <freid.DeleteThis@construire.com> wrote:
 > I am using an ADO object to access a FoxPro table (DBF file).
 >
 > The problem is when I insert new records in the table, the indexs of
 > the table are not reajusted. I expect that I must recreate or rebuild
 > the indexs but neither drop index and create index queries work.
 >
 > Any advice??
 >
 > P.S. If I can't post this kind of question in this news group please
 > tell me in witch news group I should post my question.

Hi François,

The Visual FoxPro Reindex command is not suported by either the ODBC driver
or OLE DB data provider. FoxPro's CDX index files will automatically keep
themselves up-to-date while the older (and now seldom used) IDX files will
not.

Do you know which version of FoxPro your tables were created with? Is there
a CDX file present with the same name as the table?

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden.DeleteThis@mvps.org <a style='text-decoration: underline;' href="http://www.cindywinegarden.com" target="_blank">www.cindywinegarden.com</a><!-- ~MESSAGE_AFTER~ -->