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
Don