VFP 愛用者社區

[張山]

有一表A如附图

supplypart字段为零件编码，U_Price字段为单价

但一份表内有多个零件编码是重复的，重复的编码对应的单价稍有差别

请教如何将重复编码的单价取最小值重新全部赋上

[green]

以supplypart 及 U_price 由小至大排序即可

[wuno2001]

close databases
use A
repl U_price with MIN_U_PRICE('A','supplypart',supplypart,'U_price') all

FUNCTION MIN_U_PRICE
LPARAMETERS xtable,xkey1,xvalue1,xkey2
xx="select "+xkey1+",min("+xkey2+") as xx from "+xtable+" where "+xkey1+"=xvalue1 group by "+xkey1+" into cursor temp0"
&xx
go top
yy=temp0.xx
sele &xtable
RETURN yy

試試!!

[小賴]

SELECT SupplyPart, MIN(U_Price) AS P1 FROM A GROUP BY SupplyPart INTO CURSOR Temp READWRITE
UPDATE A SET U_Price = Temp.P1 FROM Temp WHERE A.SupplyPart = Temp.SupplyPart