唯一索引错误:引入了唯一索引。需要升级脚本
我怎样才能让这个BP错误消失:唯一索引错误:引入了唯一索引。需要升级脚本。
http://msdn2.microsoft.com/en-gb/library/aa884122.aspx 告诉我实施 升级脚本。 如何实施升级脚本,这会让 BP 错误消失吗?
或者更好的是,我怎样才能在没有脚本的情况下摆脱这个错误,因为该项目还没有jet部署给客户?
How can I make this BP error go away: Unique index error: Unique index introduced. Upgrade script required.
http://msdn2.microsoft.com/en-gb/library/aa884122.aspx tells me to implement
an upgrade script.
How do I implement an upgrade script and will this make the BP error go away?
Or even better, how can I get rid of this error without the scripts, because the project has not jet deployed to customers?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(3)
如果您只是想在没有脚本的情况下消除错误,您可以相应地修改
\Classes\SysBPCheckTable\checkIndicesMoreUnique
,或者在中注释掉
。this.checkIndicesMoreUnique();
>\Classes\SysBPCheckTable\checkIf you just want to get rid of the error without the scripts you can modify
\Classes\SysBPCheckTable\checkIndicesMoreUnique
accordingly or rather comment outthis.checkIndicesMoreUnique();
in\Classes\SysBPCheckTable\check
.如果您选择忽略 BP 警告,请注意您在客户处的同步可能会因重复密钥而失败。如果 1. 客户表包含记录,2. 新索引也有新字段,则尤其如此。
您提供的链接中描述了制作更新脚本的方法。您会在
ReleaseUpdate
类中找到很多示例。If you choose to ignore the BP warning, beware that your synchronization at your customers may fail due to duplicate keys. This is especially true if 1. customer table contains records, 2. the new index has a new field as well.
The way to make an update script is described in the link you provided. You will find lots of examples in the
ReleaseUpdate
classes.在仅仅“消除”BP 错误之前,您必须首先调查该指数。索引由哪些字段组成?
如果不需要索引,并且索引位于可以删除的图层中,则删除索引。话虽如此,您之后还应该对 AOT 进行编译,以确保该索引不是代码中某处的引用(例如,使用索引提示完成选择的地方)。
但首先您需要确定创建索引的原因。
Before merely ‘getting rid of’ the BP error, you have to investigate the index first. Which fields make up the index?
If the index is not needed, and is in a layer you can delete from, then delete the index. Having said that, you should afterwards do a compile on the AOT as well to make sure that this index isn’t references somewhere in the code (for example where selects are done with index hint).
But first of all you need to establish why the index has been created.