SwissDelphiCenter.ch : ...regenerate all out-of-date indexes on a given table?

whats new ¦ programming tips ¦ indy articles ¦ intraweb articles ¦ informations ¦ links ¦ interviews ¦ misc ¦ forum
kylix ¦ tutorials ¦ online shop ¦ photos ¦ Add&Win Game

Tips (1565)

Database (91)
Files (139)
Forms (113)
Graphic (116)
IDE (21)
Indy (5)
Internet / LAN (133)
IntraWeb (0)
Kylix (10)
Math (77)
Misc (128)
Multimedia (46)
Objects/
ActiveX (51)
OpenTools API (3)
Printing (35)
Strings (83)
System (268)
VCL (246)

Top15

Tips sort by
component

Search Tip

Add new Tip

Add&Win Game

Advertising

SwissDelphiCenter is a Borland Technology Partner

...regenerate all out-of-date indexes on a given table?
Autor: Marc Geldon (GELU IT SERVICE)
Homepage: http://www.geldon.de
[ Print tip ]

Tip Rating (0):

procedure TForm1.Button1Click(Sender: TObject);
begin
  Table.Close;
  Table.Exclusive := True;
  Table.Open;
  DbiRegenIndexes(Table.Handle);
  Table.Close;
end;

Rate this tip: