【问】商品档案保存报错“第19行 ‘valtes’附近有语法的错误” | ||
【适用版本】服装之星8 | 【模块】基础业务 | 【点击数】39 |
【知识编号】Z2012112900011 | ||
【问题描述】商品档案保存时报错:第19行 ‘valtes’附近有语法的错误 |
use hbfsv8
go
drop trigger tr_bd_i_item_info
CREATE trigger tr_bd_i_item_info on t_bd_item_info WITH ENCRYPTION
for insert
as
begin
–检查是否是分部式版,如果不是则返回
if not (select sys_var_value from t_sys_system where lower(sys_var_id)=’is_distributed’) = ‘1’ return
–声明变量
declare @item_no varchar(30)
–插入
declare insert_item_cur cursor for
select item_no from inserted for read only
open insert_item_cur
fetch insert_item_cur into @item_no
while @@fetch_status=0
begin
insert into t_sys_cm_data (com_table, change_type, key1,key2, update_date, branch_no)
values (‘t_bd_item_info’, ‘I’, @item_no, @item_no, getdate(), null)
fetch insert_item_cur into @item_no
end
close insert_item_cur
deallocate insert_item_cur
end