Select to view content in your preferred language

Trigger a python script on data manipulation in SQL Server (ArcSDE/ArcServer)

625
1
03-10-2015 09:17 AM
Status: Open
Labels (1)
AntonSizo
Frequent Contributor

I would like to see an option to run a python script if a table or feature class in SDE database is changed, e.g. INSERT, DELETE, UPDATE. Something similar to TRIGGER function in  Microsoft SQL.

1 Comment
SSWoodward

Thanks for the Idea.  This functionality sounds a lot like the functionality available using Attribute Rules.  Have you looked into whether or not these might suite your needs?

Introduction to Attribute Rules

Attribute rules can be triggered on INSEERT, UPDATE, or DELETE.  They can even be triggered on a specific field, set of fields, or edits to records of a specific subtype.