Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Index is out of date 1

Status
Not open for further replies.

Gigatech

Programmer
Jul 12, 2000
80
CR
How can I fix an "Index is out of date" problem?

I try to open the table with database desktop but it say the same message.

How can I fix this problem in runtime?, I don't want my users have to do any external procedure

thanks.
 
Hello.

You can use DBiRegenIndexes to re-generate the table's indexes.

Example:

Table1.Exclusive := True;
Table1.Open;
Check(DbiRegenIndexes(Table1.Handle));

Also there is a great table repair utility called PdxrBld it comes with source so you can easily use its functionality in your application.You would also need the TUtility.dll Borland provides for PdxrBld.

Get the dll and Borlands own TUtility with source here,

Also have a look at this FAQ
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top