>>>Tsoi,
>>>
>>>VFP does not allow a SELECT inside of an UPDATE command. You can change your code to;
>>>
>>
>Bob,
>
>That's new to VFP7, VFP6 did not support subselects in an UPDATE

I don't remember this being on the enhancment list for 7.0. What else was enhanced in the VFP sql language?

BOb