资产盘点表选择某个盘点方案系统提示运行时错误94,使用null无效?
[概述]
资产盘点表4张卡片内码异常,执行语句修改。
参考语句:
select * into t_assetinvdept_bak20181031 from t_AssetInvDept where FAssetNumber in ('B04105102933-2','A05105100761-1','B04105102933-1','A05105100761-2') and FProjectID=1003
delete from t_AssetInvDept where FAssetNumber in ('B04105102933-2','A05105100761-1','B04105102933-1','A05105100761-2')
and FProjectID=1003
insert into t_AssetInvDept select 1003,fassetid,fassetnumber,fdeptid from t_AssetInvDept where FProjectID=1007 and FAssetNumber in ('B04105102933-2','A05105100761-1','B04105102933-1','A05105100761-2')
select * into t_AssetInvEntry_bak20181031 from t_AssetInvEntry where FAssetNumber in ('B04105102933-2','A05105100761-1','B04105102933-1','A05105100761-2') and FProjectID=1003
delete from t_AssetInvEntry where FAssetNumber in ('B04105102933-2','A05105100761-1','B04105102933-1','A05105100761-2') and FProjectID=1003
insert into t_AssetInvEntry select 1003,FAssetID,FAssetNumber,FAssetName,FGroupID,FUnit,FNum,FLocationID ,0,FReCurNum,FCurLocationID,16423, '2017-02-23',FReCurUserID, FReCurDate,FCreateByPrj ,FOSRBInterID, FCurRemark,FReRemark from t_AssetInvEntry where FProjectID=1007 and FAssetNumber in ('B04105102933-2','A05105100761-1','B04105102933-1','A05105100761-2')
资产盘点表选择某个盘点方案系统提示运行时错误94,使用null无效?
本文2024-09-22 13:06:37发表“k3wise知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-k3wise-66480.html