Detect when table gets updated


We currently have Windows services (written in C#, .NET) that push data out from some Sage tables to a custom API, which then stores it in a private SQL Server Database. Depending on the service, it might trigger every minute, every 5 minutes, or once every day.

We are looking for a real-time end result since the current implementation presents delays in synchronizing data.

Is there a way to trigger our code somehow when data in a specific table gets added, updated, or deleted?


Parents Reply
  • 0 in reply to Imad Maks

    BOI scripts need to be recompiled after changes, and are loaded into memory as the data entry object is opened... (with no way to "refresh" the script in that data entry session).  Eg. recompile the script, and you have to close / re-open the data entry screen to load the updated script.

No Data