在CS中更新触发器? [英] Update triggers in CS?
问题描述
大家好,
我一直在网上搜索这个问题的答案,但一直找不到任何答案。
I've been searching the web thin for an answer to this question, but haven't been able to find anything.
我们使用的是CS 2007并使用BizTalk Orders Recieve Adapter。配置适配器可能的最小轮询间隔是1分钟。然而,我们想要的是保证订单的每次更改都通过某种方式通过Biztalk。
We are on CS 2007 and using the BizTalk Orders Recieve Adapter. The minimum polling interval possible in configuring the adapter is 1 minute. What we would like is however a gurantee that every change to an order goes thru Biztalk some way.
任何想法?
我在想那里可能是某种触发器/钩子机制,允许我们在更新时将整个订单XML保存到SQL Server中。对我来说唯一的另一个解决方案是创建一个代理网络服务,所有更改都必须通过,并使用此服务
进行日志记录 - 所有用户都将删除对CS的写入权限。
I was thinking that there might be some kind of trigger/hook-mechanism allowing us to persist the entire order XML into SQL Server upon update. The only other sollution for me is to create a proxy-webservice that all changes must go thru, and have this service do the logging - all users would have their writing access to CS removed.
任何人?
谢谢!
推荐答案
我有一个类似的问题该项目。为了满足这个要求,我在订单表格中添加了日期时间戳。订单项。默认情况下,该值为null或我们将此字段设置为null的记录的任何更改。 BizTalk将只加载
的记录,这些记录是null&处理完BizTalk后,将使用时间戳更新此字段,以便不再处理。
I have similar issue in one of the project. To fulfill this requirement, I have added datetime stamp to order forms & line items. By default the value is null or any changes to the record we are making this field to null. BizTalk will load only the records which are null & once processed BizTalk will update this field with timestamp so that it is not processed again.
这篇关于在CS中更新触发器?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!