We have a client that would like to have a menu item that the users can use to update a single index. They currently have the APPMAIN menu on their applications' main menu but this can obviously lead to trouble. What I need to do is create some type of procedure to do the equivalent of selecting the menu items ,"DB Admin" ] "Indexes" ] "Update" ] "Rebuild Indexes for one or more colums" via a new menu that will start procedures to update one indexed field in one specific table.

Is this possible?

Any help will be greatly appreciated.

André

[email protected]

Use message boxes or popups or whatever to gather the appropriate table and column information, and then call INDEX.FLUSH.

It's not that hard to do.

I'm assuming you have a relatively small list of tables that are indexed and their columns, so that could be hard coded, or stored in a table.

If not, I'm not sure how to collect indexing information programatically, but I'm sure it can be done.

Matt Sorrell

Thanks Matt. I had seen the Index.Flush command before but for some reason skipped by it. Appreciate the help.

André

View this thread on the forum...