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

栏目:云星空知识作者:金蝶来源:金蝶云社区发布:2024-09-23浏览:1

前台点付款报错,提示对象名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                  null,
    FCancelId            bigint               null,
    FTrade_No            varchar(150)         null,
    FRefund_Id           varchar(150)         null,
    FOut_Trade_No        varchar(150)         null,
    FShopId              bigint               null,
    FShopDay             datetime             null,
    constraint PK_POS_QUICKPASS_FID primary key (FId)
 )
 create index IX_POS_QuickPass_FBillId on POS_QuickPass (FBillId ASC)
end
go

IF NOT  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'T_DIN_CustomerFoodType') AND name = N'PK_T_DIN_CustomerFoodType')
BEGIN
ALTER TABLE T_DIN_CustomerFoodType ADD  CONSTRAINT [PK_T_DIN_CustomerFoodType] PRIMARY KEY CLUSTERED
(
 [FID] ASC
)
END
GO


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

问题描述:前台点付款报错,提示对象名pos_quickpass 无效解决方案:执行以下脚本/*[3664]*/--增加银盲记录信息表IF NOT EXISTS (SELE...
点击下载文档
确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息