Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Reindex a FoxPro Table by SQL command

397 views
Skip to first unread message

François Reid

unread,
Apr 20, 2004, 11:43:24 AM4/20/04
to
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

Cindy Winegarden

unread,
Apr 21, 2004, 11:04:46 AM4/21/04
to
In news: i8ha80t22qirkir04...@4ax.com,

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.wi...@mvps.org www.cindywinegarden.com

0 new messages