Hi Carla.

>I need to eliminate all the indexes files in my tables and create all again programatically, but I have a primary key with a FOR clause (Not deleted()), how can I create programatically this for clause again.

You might be interested in a tool called Stonefield Database Toolkit (SDT). It can recreate all the indexes for your tables and avoid problems like this (even in VFP 5, which doesn't allow you to recreate filtered primary keys programmatically), and properly handles persistent relations between tables (which are deleted if you use DELETE TAG ALL). It'll even handle the case where an index is so badly damaged that merely opening the table causes VFP to GPF. In addition to recreating indexes, it can repair corrupted table and memo headers and create or update table structures at remote sites. PUTM members get a 10% discount on SDT.

For more information or a demo version, check out .

Doug