>Has anyone gotten anything like this to work in VFP?
>If so, could you share some examples? Or any examples of Update/Select working together.
>
>UDPATE t1
> SET rate = rate + (SELECT increase FROM t2 WHERE id = t1.id)
>
Steve, 9-01-98
This is easy as pie in Fox.
use t2 order tag id
select 0
use t1 && in any order
set relat to id into t2
browse fields id,rate,t2.id,t2.increase && look before you leap
replace all rate with rate+t2.increase && perform the update
I've used SQL, too, and it makes everything harder than in Fox.
Good Luck,
Gary Nemeth
Gary Nemeth, 440-333-3432