Hi,

Does anyone know whether the Clear_Table command updates indexes on the table as well as clearing the data.

It seems to take a long time on indexed tables?

Running from command prompt: run clear_table "Tablename"

Thanks,

Steve Penney

Steve,

Clear_Table should update the index. How big is your table? I ran a test on a table with 3 indexed fields and 1 million records and the Clear_Table took approx. 2 1/2 minutes. The data was deleted and the indexes were updated.

Sean

View this thread on the Works forum...