前台点付款报错,提示对象名pos_quickpass 无效

问题描述:
前台点付款报错,提示对象名pos_quickpass 无效
解决方案:
执行以下脚本
/*[3664]*/
--增加银盲记录信息表
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'POS_BlindGiveInfo') AND type IN (N'U'))
BEGIN
CREATE TABLE POS_BlindGiveInfo(
[FShopID] [INT] NOT NULL,
[FShopDay] [DATETIME] NOT NULL,
[FStationNo] [VARCHAR](5) NOT NULL,
[FMoreCount] [INT] NOT NULL,
[FInputAmt] [DECIMAL](23, 11) NOT NULL,
[FEmpID] [INT] NOT NULL,
[FOperateDate] [DATETIME] NOT NULL,
CONSTRAINT [PK_POS_BlindGiveInfo] PRIMARY KEY CLUSTERED
(
[FShopID] ASC,
[FShopDay] ASC,
[FStationNo] ASC,
[FMoreCount] ASC
)
) ON [PRIMARY]
END
GO
if not exists (select 1 from sysobjects where id = object_id('POS_QuickPass') and type = 'U')
Begin
Create table POS_QuickPass
(
FId bigint identity,
FBillId bigint not null,
FPayAmt decimal(23,4) not null,
FPayState int not null,
FPayTime datetime not null default GetDate(),
FEmpId int
前台点付款报错,提示对象名pos_quickpass 无效
声明:除非特别标注,否则均为本站原创文章,转载时请以链接形式注明文章出处。如若本站内容侵犯了原著者的合法权益,可联系本站删除。



