Hi Donald,
remove the FROM Statement (this infront of WHERE)

UPDATE a lar_sum ;
 SET lar_sum.pj_id = dd_proj.pj_id ;
 WHERE lar_sum.larno+ALLTRIM(lar_sum.CLS)+ALLTRIM(STR(INT(VAL(lar_sum.hno))))+ALLTRIM(lar_sum.AVAIL)+RIGHT(STR(INT(lar_sum.fy)),2) ;
 IN (SELECT;
 larno+cls_hno_av;
 FROM lar_sum_match_proj_nj) ;
 AND ALLTRIM(lar_sum.CLS)+ALLTRIM(STR(INT(VAL(lar_sum.hno))))+ALLTRIM(lar_sum.AVAIL)+RIGHT(STR(INT(lar_sum.fy)),2) = dd_proj.pj_pcode

if this is not of help, try if the SELECT statement runs alone and if the update runs without subquery.


HTH Agnes



>The following standard ANSI-SQL UPDATE statement fails in VFP 8.
>
>UPDATE lar_sum ;
> SET lar_sum.pj_id = dd_proj.pj_id ;
>FROM lar_sum, dd_proj ;
> WHERE lar_sum.larno+ALLTRIM(lar_sum.cls)+ALLTRIM(STR(INT(VAL(lar_sum.hno))))+ALLTRIM(lar_sum.avail)+RIGHT(STR(INT(lar_sum.fy)),2) ;
> IN (Select larno+cls_hno_av from lar_sum_match_proj_nj) ;
> AND ALLTRIM(lar_sum.cls)+ALLTRIM(STR(INT(VAL(lar_sum.hno))))+ALLTRIM(lar_sum.avail)+RIGHT(STR(INT(lar_sum.fy)),2) = DD_Proj.pj_pcode
>
>What is the problem, and the solution to this FAIL?
>
>Fred Z