>UPDATE moneyfields SET ttladjusts = ;
> (SELECT query.adjusts FROM query JOIN moneyfields ON VAL(query.control) = VAL(moneyfields.control))
>
>Perhaps needless to say - this does not run. An error is generated of the form "Function name is missing )".
>
>Any suggestions please? /psb
>
The typical fox way is to use a replace with a seek, e.g.
select query
index on val(control) tag tag1
select moneyfields
replace ttladjusts with query.adjusts ;
for seek(val(moneyfields.control), "query", "tag1") ;
in moneyfields
Insanity: Doing the same thing over and over and expecting different results.