DRP修改说明及SQL更新 2010-06-21.docx

1、1, 把现有打印页面显示的列记录好备用。2, 使用下面的SQL在查询分析器中对数据库更新：-入库单打印数据窗口历史模板清空updateIstTblNamessetsavcdtitlcdw=null,savedgriddw=nullwheretblName='dwjhinfo_ordtojh_billlist'-入库单打印数据窗口历史模板备份savetitledw:release9;datawindow(units=0timcr_intcrval=Ocolor=167772I5proccssing=0print.printername=""print.docu

2、mentname=""print.orientation=0print.margin.left=l10print.margin.right=l10print.margin.top=96print.margin.bottom=96print.papcr.sizc=Oprint.savegirddw:-release9;datawindow(units=0timer_interval=Ocolor=1073741824processing=lprint.printernaine=""prini.documentname=""prinl.o

3、rientation=0print.margin.left=l10piint.maigin.right=l10print.margin.top=96print.margin.bottom=96print.paper.size=Oprin-出库单打印数据窗口历史模板清空updateIstTblNamessetsavcdtitlcdw=null,savedgriddw=nullwheretblName='dw_slinfo_shipmcnt_b山list_detail'3, 恢复原报表显示的列（1中记录的），把不该显示的列勾去。由于把两个报表的历史模板清空了，列的显示可能需要重新设

4、置其中，入库报表：条码，商品规格，零头，单价必须显示，否则在页脚的凡个签名也不会显示出库报表：商品编号，条码，规格，大单位数量必须显示，否则在页脚的几个签名也不会显示deleteIstColNamesfromIstTblNamesa,IstColNamesbwherea.id=b.lstTbllDanda.tblName='dwjhinfo_ordtojh_billlist'g。deleteIstTblNameswheretblName='dw_jhinfo_ordtojh_billlist'g。deleteIstColNamesfromIstTblNamesa,IstColNamesbwherea.id=b.lstTbllDanda.tblName='dw_slinfo_shipment_biinist_detairgodeleteIstTblNameswheretblName='dw_slinfo_shipment_bi111ist_detaiI'goselect*fromIstTblNameswheretblNamewheretblName'dw_jhinfo_ordtojh_billlist'select*fromIstTblNamesa,Isl