Binding information is invalid--哪位大佬能解答一下？

2018-03-06 05:27:46 871 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

Codesys.运动控制修改凸轮点通过改凸轮曲线的主从轴缩放比例或者偏置。新建多个凸轮曲线，对CAM曲线进行切换。程序中动态修改，仅修改中间的关键点(凸轮末点修改or凸轮曲线运行中修改)。程序中动态修改，修改首未关键点及关键点个数，需要重新触发MC_TableSelect。使用程序新建凸轮表代码，实现电子凸轮基本运动。我们讲的凸轮表切换、关键点修改、程序新建电子凸轮，这些方法没有本质区别，总之都是“趁曲线不注意，把凸轮表改了。阅读详情

OLE DB provider "SQLNCLI10" for linked server "KUP" returned message "Binding information is invalid.".
Msg 7341, Level 16, State 2, Line 1
Cannot get the current row value of column "[KUP].[KUP].[dbo].[J_V_Product].Sterilization" from OLE DB provider "SQLNCLI10" for linked server "KUP".
这个是我在查询一个linked server时返回的错误，大佬们帮忙看看是怎么造成的呢？其中，J_V_product是个视图。里面就是个查询语句。引用表的语句：





CREATE TABLE [dbo].[J_Product](

	[ItemID] [uniqueidentifier] NOT NULL,

	[ItemCode] [varchar](100) NOT NULL,

	[ItemType] [int] NOT NULL,

	[Name_CN] [nvarchar](1000) NULL,

	[Name_EN] [nvarchar](1000) NULL,

	[UOM] [nvarchar](50) NULL,

	[IsImported] [bit] NULL,

	[ApplicationScope] [nvarchar](max) NULL,

	[Description] [nvarchar](max) NULL,

	[REF] [nvarchar](max) NULL,

	[SPEC] [nvarchar](max) NULL,

	[Material] [nvarchar](1000) NULL,

	[KeyProductFlag] [bit] NOT NULL,

	[NewProductFlag] [bit] NOT NULL,

	[KitFlag] [bit] NOT NULL,

	[CompanyCategory1] [nvarchar](1000) NULL,

	[CompanyCategory2] [nvarchar](1000) NULL,

	[J1] [nvarchar](1000) NULL,

	[J2] [nvarchar](1000) NULL,

	[J3] [nvarchar](1000) NULL,

	[Manufacturer] [nvarchar](max) NULL,

	[MinPrice] [decimal](18, 2) NULL,

	[MaxPrice] [decimal](18, 2) NULL,

	[AlertPrice] [decimal](18, 2) NULL,

	[DivisionID] [uniqueidentifier] NULL,

	[StructureAndComposition] [nvarchar](max) NULL,

	[LifeDescription] [nvarchar](max) NULL,

	[TradeName] [nvarchar](1000) NULL,

	[OneTimeUsage] [bit] NULL,

	[AgentRegAddress] [nvarchar](1000) NULL,

	[AgentName] [nvarchar](1000) NULL,

	[AgentTelNumber] [nvarchar](50) NULL,

	[StandardCode] [nvarchar](max) NULL,

	[ManufacturerAddress1] [nvarchar](1000) NULL,

	[ManufacturerAddress2] [nvarchar](1000) NULL,

	[RegProductName] [nvarchar](1000) NULL,

	[PriceBuffer1] [decimal](18, 2) NULL,

	[PriceBuffer2] [decimal](18, 2) NULL,

	[Indication] [nvarchar](max) NULL,

	[ManufacturerEN] [nvarchar](1000) NULL,

	[MinSPEC] [nvarchar](1000) NULL,

	[Contraindication] [nvarchar](max) NULL,

	[Memo] [nvarchar](500) NULL,

	[StorageCondition] [nvarchar](max) NULL,

	[ServiceProvider] [nvarchar](max) NULL,

	[OriginalCountry] [nvarchar](max) NULL,

	[Brand] [nvarchar](50) NULL,

	[IsEquipment] [bit] NULL,

	[IsImplantation] [bit] NULL,

	[IsConsumptive] [bit] NULL,

	[ValuePeriod] [varchar](50) NULL,

	[PackageMaterial] [nvarchar](50) NULL,

	[PackageRate] [decimal](18, 2) NULL,

	[Sterilization] [nvarchar](max) NULL,

	[InspectionReportNumber] [nvarchar](50) NULL,

	[InspectionReportDate] [date] NULL,

	[DT] [datetime] NULL,

	[ST] [int] NOT NULL,

	[MinPricingSPEC] [nvarchar](50) NULL,

	[SterilizationMethod] [nvarchar](max) NULL,

	[JNJUnitRate] [decimal](18, 2) NULL,

	[MinPackageRate] [decimal](18, 2) NULL,

	[MinPackageName] [nvarchar](50) NULL,

	[JNJOutboundPackageName] [nvarchar](50) NULL,

	[JNJStandardUnitRate] [decimal](18, 2) NULL,

 CONSTRAINT [PK_J_Product] PRIMARY KEY CLUSTERED 

(

	[ItemID] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]



GO



SET ANSI_PADDING OFF

GO



EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'1 单品  2组件  3组套' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'J_Product', @level2type=N'COLUMN',@level2name=N'ItemType'

GO



EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'1：进口  2：国产' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'J_Product', @level2type=N'COLUMN',@level2name=N'IsImported'

GO



EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'适用范围' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'J_Product', @level2type=N'COLUMN',@level2name=N'ApplicationScope'

GO



ALTER TABLE [dbo].[J_Product] ADD  CONSTRAINT [DF_J_Product_ItemType]  DEFAULT ((1)) FOR [ItemType]

GO



ALTER TABLE [dbo].[J_Product] ADD  CONSTRAINT [DF_J_Product_IsImported]  DEFAULT ((1)) FOR [IsImported]

GO



ALTER TABLE [dbo].[J_Product] ADD  CONSTRAINT [DF_J_Product_KeyProductFlag]  DEFAULT ((0)) FOR [KeyProductFlag]

GO



ALTER TABLE [dbo].[J_Product] ADD  CONSTRAINT [DF_J_Product_NewProductFlag]  DEFAULT ((0)) FOR [NewProductFlag]

GO



ALTER TABLE [dbo].[J_Product] ADD  CONSTRAINT [DF_J_Product_KitFlag]  DEFAULT ((0)) FOR [KitFlag]

GO



ALTER TABLE [dbo].[J_Product] ADD  CONSTRAINT [DF_J_Product_OneTimeUsage]  DEFAULT ((0)) FOR [OneTimeUsage]

GO



ALTER TABLE [dbo].[J_Product] ADD  CONSTRAINT [DF_J_Product_ST]  DEFAULT ((1)) FOR [ST]

GO