Well. I tried with all possible SET TABLEVALIDATE values.
It dit not affect the speed at all. Very slow with VFP8.

It might be a problem with the indexes when upgrading the
tables from VFP7 TO VFP8. Does any one have any experience
in upgrading tables from VFP7 to VFP8.


>>>>With VFP7 it takes less than a second to update the table.
>>>>With VFP8 it takes more than 3 minutes
>>>Have you checked out SET TABLEVALIDATE? This might be what's slowing you down.
>>No. What the SET TABLEVALIDATE has to do with the TABLEUPDATE ?
>
>If TABLEVALIDATE is set to 2 or 3, it validates the record count on every insert. I'm wondering if that could be your problem here.