Hi all,
I type the following sql command in foxpro environment but an error returns:

function name is missing.

I cannot find anything wrong with following statement.
---------
update vehicle set brc_id=(select co_brc from co_temp where cbpo_ref = cbpo_num) where empty(brc_id)=.t.
---------

vehicle table: brc_id, cbpo_num
co_temp table: co_brc, cbpo_ref

but if I change the statement as following, it can work

select co_brc from co_temp where cbpo_ref = '2'

Anything wrong?
Linda