>Hi Hilmar, with your answer I have two more questions:
>- Is the SQL statement out of limits with 100 fields? I think VFP limit is of 8 KB per statement, which is a lot
>- Why does the error go out when I force all rows to be updated?
I don't know the answers. But I still think that you should try "key fields only", to see if that works better.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)