>Bob,
>
>Actually checking the VFP 7.0 help file, it also does not support SELECT in the WHERE clause of the UPDATE command.
The VFP7 help isn't lying when it says that "subqueries are supported in UPDATE – SQL" but it doesn't specify that they are only supported in the WHERE clause. The following is legitimate command (VFP 6 and 7)
UPDATE orders Set Status = "UPDATED" ;
WHERE cust_id in ( SELECT cust_id FROM customer WHERE region = "SP" )
--sb--