旗舰版4.2升级到5.0报错,无法升级
665次浏览
编辑于2018年01月10日 22:57:01
数据库升级失败!SQL文件不全或SQL语句有误!
错误描述:列名 'FIsTrans2WebOrder' 无效。
Sql文件名:C:\PROGRAM FILES (X86)\KINGDEE\KISERP\KISEXPRESS\KDSYSTEM\KDCOM\SqlSrv\SP_KISUEV5.0ECProc.sql
Sql内容:
--[NO SQL FILE INFOMATION]
CREATE PROCEDURE SP_CancelERPOrder2WebOrder
@FInterID as INT,
@Status AS INT OUTPUT,
@ErrMsg AS Varchar(1000) OUTPUT
AS
BEGIN
declare @FID as int
declare @FBillNo varchar(500)
declare @OutInterID as int
declare @FIDS table(FID int)
set @FID = 0
set @OutInterID = 0
set @ErrMsg = ''
set @Status = 0
SELECT @FBillNo = isnull(FBillNo,'')from SEOrder where FInterID = @FInterID
--SELECT @FID=FID from IC_Web2ERPOrders where FSiteOrderID = convert(varchar(500),@FInterID
...
错误描述:列名 'FIsTrans2WebOrder' 无效。
Sql文件名:C:\PROGRAM FILES (X86)\KINGDEE\KISERP\KISEXPRESS\KDSYSTEM\KDCOM\SqlSrv\SP_KISUEV5.0ECProc.sql
Sql内容:
--[NO SQL FILE INFOMATION]
CREATE PROCEDURE SP_CancelERPOrder2WebOrder
@FInterID as INT,
@Status AS INT OUTPUT,
@ErrMsg AS Varchar(1000) OUTPUT
AS
BEGIN
declare @FID as int
declare @FBillNo varchar(500)
declare @OutInterID as int
declare @FIDS table(FID int)
set @FID = 0
set @OutInterID = 0
set @ErrMsg = ''
set @Status = 0
SELECT @FBillNo = isnull(FBillNo,'')from SEOrder where FInterID = @FInterID
--SELECT @FID=FID from IC_Web2ERPOrders where FSiteOrderID = convert(varchar(500),@FInterID
...
推荐阅读