【问题描述】
现在客户条码跟快捷键有冲突,怎么处理此问题,前台扫描扫描不出来!
【问题答案】
若条码打印的是货号,可将货号中的小写字母都改为大写后再重新打条码,备份好数据库后在总部执行以下语句:
–将货号中存在小写的字母修改成大写
use hbfsv9
go
declare @ls_tablename varchar(50),@ls_sql varchar(500)
declare test_cur cursor for
SELECT pbc_tnam
FROM pbcatcol
WHERE pbc_cnam = ‘item_no’
ORDER BY pbc_tnam
for read only
open test_cur
fetch test_cur into @ls_tablename;
while @@fetch_Status = 0
begin
set @ls_sql=’update’ +’ ‘ +@ls_tablename+’ set item_no=upper(item_no)’
exec( @ls_sql)
fetch test_cur into @ls_tablename;
end
close test_cur
deallocate test_cur
go