Very Computer

I am trying to embed one SQL statement inside another as:
           UPDATE client:
             SET country = (SELECT ID FROM countries WHERE
countries.NAME = c_country) ;
             WHERE client.client_id = sequence_table.client_id
but I receive an error message "Function name is missing)."

There is an MSDN example as follows:
           SELECT company FROM customer a WHERE ;
              EXISTS (SELECT * FROM orders b WHERE a.postalcode =
b.postalcode)
so SQL statments can be embedded in other SQL statements.

I've tried variations on the syntax without success. Can anyone help me
with this?

Thanks
Ron St.Pierre

PS In case it helps, what I am trying to do is use the COUNTRIES table
as a lookup table. The user selects the country, and the associated
Integer value from the COUNTRIES table will be inserted into my CLIENT
table.

Ron
You're ahead of the game. That's hopefully an SQL standard that VFP will
implement some day.
You can do
UPDATE Clients SET country = 'x' ;
WHERE EXISTS (Select * FROM sequence_table ST WHERE
Clients.client_id=ST.client_id)
but you can replace 'x' with a subquery. You can mix in some xbase code:
 USE Countries IN 0
 UPDATE clients SET country = LOOKUP(Countries.id, c_country,'Countries') ;
 WHERE EXISTS ...
You could use an update statement like yours in SQL Pass-through against
Oracle or SQLServer
-Anders

Quote:> I am trying to embed one SQL statement inside another as:
>            UPDATE client:
>              SET country = (SELECT ID FROM countries WHERE
> countries.NAME = c_country) ;
>              WHERE client.client_id = sequence_table.client_id
> but I receive an error message "Function name is missing)."

> There is an MSDN example as follows:
>            SELECT company FROM customer a WHERE ;
>               EXISTS (SELECT * FROM orders b WHERE a.postalcode =
> b.postalcode)
> so SQL statments can be embedded in other SQL statements.

> I've tried variations on the syntax without success. Can anyone help me
> with this?

> Thanks
> Ron St.Pierre

> PS In case it helps, what I am trying to do is use the COUNTRIES table
> as a lookup table. The user selects the country, and the associated
> Integer value from the COUNTRIES table will be inserted into my CLIENT
> table.