UFDATA视图或函数 'hy_VoucherItems' 不可更新，因为修改会影响多个基表

数据库名: UFDATA_018_2024 D:\U8SOFT\Admin\SQLFILE15000\Main\Ufdata\data\NL\data_data_so_u81300_nl.sql 错误信息:-2147217900 视图或函数 'hy_VoucherItems' 不可更新，因为修改会影响多个基表。 执行如下语句时出错: --调拨单表体添加现存量add by gr150928 declare @VT_ID as varchar(100) select top 1 @VT_ID=VT_ID from hy_VoucherTemplates where VT_CardNumber='BCTransD' and VT_TemplateMode=0 and VT_Name=N'扫描调拨单表体显示模版' if exists(select localeID from u8langdefine where localeID='zh-cn') if not exists(select * from hy_VoucherItems where localeid='zh-cn' and CardNum='BCTransD' and VT_ID=@VT_ID and FieldName='CurrentStock' and CardSection='T') insert into hy_VoucherItems ( AliasNum,AutoFillRule,BuildArchives,bZeroAllowable,CalcField,CanDelete, CanModify,CanNotSelect,cardformula1,cardformula2,carditemname,CardItemNum,CardNum,CardSection,cmemo, COX,COY,DataRule,DataSource,DefaultValue,EnterType,EnumType,EnumTypeString,FieldName,FieldType,FontState, FormatChar,FormatData,Height,iFlags,IsEnum,IsFixedLenght,IsMain,IsNull,isSelfDef,LinkField,LinkIt,LinkTbl, localeid,MaxLength,MaxShowLen,nBorder,NeedSum,NumPoint,PrintCaption, PrintInterval,PrintUpcase,ReferReturnField,ReferTable,ReferType,refObject, ReserveSegTitlePos,ShowIt,TabIndex,TableName,UserCheck,UserPrompt,ValidityCheck,VT_ID,vValueDefault,Width ) values (null, null, '0', '1', null, 1, '1', '0', '现存量', '现存量', '现存量', '3', 'BCTransD', 'T', null, 120, 1680, '', 0, '', 0, null, null, 'CurrentStock', 1, '宋体,9,0,0,1', null, '', 200, 0, null, null, null, '0', null, null, null, null, 'zh-cn', 20, null, 0, 0, 0, '1', '', '0', null, null, 1, null, '1', '0', 0, null, null, null, '0', @VT_ID , '', 2205) else update hy_VoucherItems set carditemnum= '3', cannotselect= '0', candelete= 1, isnull= '0', maxlength= 20, cardformula1= '现存量', cardformula2= '现存量', carditemname= '现存量', IsEnum=null, EnumType=null, EnumTypeString=null, refobject=null, NeedSum= 0, MaxShowLen=null, bZeroAllowable= '1', TableName=null, iFlags= 0