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
This command, which works fine in SQL Server (have similar database, and tables mirroring .DBC/.DBFs).
How do I get this to work in VFP 8?
Fred Z - Boston MA
Don