处理外部编程应用程序中的db事件 [英] Handle db events in external programming application

问题描述

大家好，


我需要检测数据库中何时发生更新/更改，但是通过选择查询每秒检查一次并不是很好当然，处理时间太长..


有没有办法创建一个方法作为数据库内发生的事件的事件处理程序？


什么是最佳解决方案？所以我可以更新我的VB屏幕，例如只有当数据库中发生更改时...


提前感谢，

Thiago。

Hello all,

I am in need of detecting when an update/change occurred in the database, but checking it every second by selecting queries is not good as will take, of course, too much process time..

Is there a way of creating a method as an event handler of an event happening inside the database??

Whats the best solution for this? so I could update my VB screen for example only when changes occurr in the database..

thanks in advance,
Thiago.

推荐答案

你想观看整个数据库还是单个表格？

Do you want to watch the entire database or a single table out of it ???

你想观看整个数据库还是单个表格？

Do you want to watch the entire database or a single table out of it ???

这并不重要，它们中的任何一个都会很棒，因为似乎没有人知道如何做到这一点......当你可以帮助我表或整个数据库..但在我的情况下，一个表应该就够了。


我总是想知道如何做到这一点，因为许多大型应用程序需要这样一个似乎很合乎逻辑事情，所以我认为它应该是可能的......不是吗？

It does not really matter, any of them would be great already because it seems nobody knows how to do this.. its ok when you can help me with a single table or an entire database.. but in my case one table should be enough.

I always wondered how this could be done because it seems very logical that many large applications would need such a thing, so I think it should be possible.. isnt it?

在你要观看的桌子上写一个触发器。

在事件上写下触发器你想看它（插入/更新/删除）。


每次事件发生时都会跟踪日志表中的相同内容。


尝试从日志表中更新你的VB应用程序。


如果你还有回复，请回帖。

write a trigger on the table u want to watch .
write the trigger on the event you want to watch it (insert/update/delete).

every time an event occurs track the same in a log table.

try to update your VB application from the log table.

If u still have boubts do post back.

这篇关于处理外部编程应用程序中的db事件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！