管家婆数据排序

---

• design by xuhu 20210315
• 查询全部定单并排序

---

*说明：

• DLYNDX.DBF 加字段recn_no, 数字型

• 暂时没有过滤红字反冲

• 表说明 ：

• DLYNEX 单据编号 DLY 单据明细

• PTYPE 商品名称

SET CENTURY ON
set date ymd
Set Mark To [-]

• 日期为 yyyy-mm-dd

*路径 为当前的
SET DEFAULT TO “d:\xuhu\管家婆\data - 副本”

*2.qpr
SELECT Dly.date, Dly.vchcode, Dly.drecno_b, Ptype.fullname, Dly.qty,;
Dly.price, Dly.comment;
FROM dly INNER JOIN ptype ;
ON Dly.drecno_p = Ptype.rec_no ;
INTO TABLE temp1.dbf

• 3.qpr
• btype.dbf 客户名
  SELECT Temp1.date, Temp1.vchcode, Btype.fullname, Temp1.fullname,;
  ABS(Temp1.qty), Temp1.price, Temp1.comment;
  FROM temp1 LEFT OUTER JOIN btype ;
  ON Temp1.drecno_b = Btype.rec_no;
  ORDER BY Btype.fullname, Temp1.fullname, Temp1.date INTO TABLE temp2.dbf

COPY TO “d:\xuhu\管家婆\data - 副本\1.xls” TYPE XL5