數(shù)據(jù)庫名: UFDATA_018_2024 D:\U8SOFT\Admin\SQLFILE15000\Main\Ufdata\data\NL\data_data_so_u81300_nl.sql 錯誤信息:-2147217900 視圖或函數(shù) 'hy_VoucherItems' 不可更新，因為修改會影響多個基表。 執(zhí)行如下語句時出錯: --調(diào)撥單表體添加現(xiàn)存量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'掃描調(diào)撥單表體顯示模版' 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', '現(xiàn)存量', '現(xiàn)存量', '現(xiàn)存量', '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= '現(xiàn)存量', cardformula2= '現(xiàn)存量', carditemname= '現(xiàn)存量', IsEnum=null, EnumType=null, EnumTypeString=null, refobject=null, NeedSum= 0, MaxShowLen=null, bZeroAllowable= '1', TableName=null, iFlags= 0