VFP 愛用者社區

[messenger]

UPDATE specmonths SET ;
specmonths.s_pname = A2.s_pname, specmonths.s_npric = A2.s_npric, specmonths.s_upric = A2.s_upric, specmonths.s_upric2 = A2.s_upric2, specmonths.s_ncpric = A2.s_ncpric, ;
specmonths.s_ucpric = A2.s_ucpric, specmonths.s_ucpric2 = A2.s_ucpric2, specmonths.p_mdate = Date(), specmonths.p_modify = yyy.y_clerk ;
From specmonths A1 JOIN specmonths AS ON specmonths.s_id = A2.s_id;
WHERE specmonths.p_id = .txtP_id.Value AND Year(A2.p_id) = curspecm.lyear, Month(A2.p_id) = curspecm.lmonth

[nelsonchuang]

好深奧~

[syntech]

SO ?

你想說什麼?