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
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]