宏景医药维护 |
1.更新程序 问题:在合同处理中在更新zy_yp1_yfzk中的cfbj是原合同程序将T写成了F,使得在合同付款审请中应收和应付相反,运行以下两名,并更新程序. UPDATE ZY_YP1_YFZK SET CFBJ=A.CFBJ FROM ZY_YP1_HTMAIN A,ZY_YP1_YFZK B WHERE A.HTBH=B.HTBH AND A.CFBJ<>B.CFBJ |
宏景医药维护 |
1.更新程序 问题:在合同处理中在更新zy_yp1_yfzk中的cfbj是原合同程序将T写成了F,使得在合同付款审请中应收和应付相反,运行以下两名,并更新程序. UPDATE ZY_YP1_YFZK SET CFBJ=A.CFBJ FROM ZY_YP1_HTMAIN A,ZY_YP1_YFZK B WHERE A.HTBH=B.HTBH AND A.CFBJ<>B.CFBJ |