Hello, I have been researching creating triggers in SQL to update the edit date and acreage values when an edit is completed on an SDE versioned feature class. I have created the triggers and SQL says that the command is completed successfully, but when I make an edit to the feature class, those fields don't get updated. I am using SQL Server 2008 R2 Management Studio Express and ArcGIS 10.2.1. The feature class is versioned and I am only using the default version. No other versions were created from that. So, I don't need to reconcile any versions back to the default version. The code I am using is below. Use [ DNR_SDE ] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TRIGGER [ DNR_Edit ] . [ trg_insert_acres_date_fields ] ON [ DNR_Edit ] . [ TRIBAL_TRUST_LANDS ] AFTER INSERT , UPDATE AS BEGIN SET NOCOUNT ON ; UPDATE [ DNR_Edit ] . [ TRIBAL_TRUST_LANDS ] SET edit_date = getdate ( ) WHERE OBJECTID IN ( SELECT OBJECTID FROM INSERTED ) UPDATE [ DNR_EDIT ] . [ TRIBAL_TRUST_LANDS ] SET Acres = shape . STArea ( ) * 0.000247105 WHERE OBJECTID IN ( SELECT OBJECTID FROM INSERTED ) END Is there a potential delay with a versioned FC before the fields get populated? I know others have used this same coding for an editable GIS web application and it is immediate, but I cannot figure out why it won't work for me. Also, I would like to have a trigger that would automatically populate the latitude and longitude coordinates for any point added to a feature class or existing point adjusted. Is there any way to do that? Thanks in advance for any assistance. Lisa

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

SQL Trigger in Versioned SDE

LisaDygert1

Hello,

I have been researching creating triggers in SQL to update the edit date and acreage values when an edit is completed on an SDE versioned feature class. I have created the triggers and SQL says that the command is completed successfully, but when I make an edit to the feature class, those fields don't get updated.

I am using SQL Server 2008 R2 Management Studio Express and ArcGIS 10.2.1. The feature class is versioned and I am only using the default version. No other versions were created from that. So, I don't need to reconcile any versions back to the default version. The code I am using is below.

<SPAN class="keyword token">Use</SPAN> <SPAN class="punctuation token">[</SPAN>DNR_SDE<SPAN class="punctuation token">]</SPAN>
GO
<SPAN class="keyword token">SET</SPAN> ANSI_NULLS <SPAN class="keyword token">ON</SPAN>
GO
<SPAN class="keyword token">SET</SPAN> QUOTED_IDENTIFIER <SPAN class="keyword token">ON</SPAN>
GO

<SPAN class="keyword token">CREATE</SPAN> <SPAN class="keyword token">TRIGGER</SPAN> <SPAN class="punctuation token">[</SPAN>DNR_Edit<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>trg_insert_acres_date_fields<SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">ON</SPAN> <SPAN class="punctuation token">[</SPAN>DNR_Edit<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>TRIBAL_TRUST_LANDS<SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">AFTER</SPAN> <SPAN class="keyword token">INSERT</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">UPDATE</SPAN>
<SPAN class="keyword token">AS</SPAN>
<SPAN class="keyword token">BEGIN</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">SET</SPAN> NOCOUNT <SPAN class="keyword token">ON</SPAN><SPAN class="punctuation token">;</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">UPDATE</SPAN> <SPAN class="punctuation token">[</SPAN>DNR_Edit<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>TRIBAL_TRUST_LANDS<SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">SET</SPAN> edit_date <SPAN class="operator token">=</SPAN> getdate<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">WHERE</SPAN> OBJECTID <SPAN class="operator token">IN</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">SELECT</SPAN> OBJECTID <SPAN class="keyword token">FROM</SPAN> INSERTED<SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">UPDATE</SPAN> <SPAN class="punctuation token">[</SPAN>DNR_EDIT<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>TRIBAL_TRUST_LANDS<SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">SET</SPAN> Acres <SPAN class="operator token">=</SPAN> shape<SPAN class="punctuation token">.</SPAN>STArea<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">*</SPAN> <SPAN class="number token">0.000247105</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">WHERE</SPAN> OBJECTID <SPAN class="operator token">IN</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">SELECT</SPAN> OBJECTID <SPAN class="keyword token">FROM</SPAN> INSERTED<SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">END</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Is there a potential delay with a versioned FC before the fields get populated? I know others have used this same coding for an editable GIS web application and it is immediate, but I cannot figure out why it won't work for me.

Also, I would like to have a trigger that would automatically populate the latitude and longitude coordinates for any point added to a feature class or existing point adjusted. Is there any way to do that?

Thanks in advance for any assistance.

Lisa

Find more posts tagged with

Accepted answers

jskinner

Hi Lisa,

When dealing with versioned data, the delta tables (A & D) are updated when a feature is created/deleted/modified. What you will need to do is create two triggers. One on the A table for inserts (creating new features) and another trigger on the D table for updates (moving/modifying features/attributes).

To find the A and D table, you can query the table_registry table:

select registration_id from sde.sde_table_registry where table_name = 'TRIBAL_TRUST_LANDS'

Note: If you are using a DBO schema, change sde.sde_table_registry to dbo.sde_table_registry.

This query will return the registration_id that you can use to query the A & D tables. Ex:

DNR_Edit.a483

DNR_Edit.d483

You can then create the triggers on each of these tables:

CREATE TRIGGER [DNR_Edit].[trg_insert_acres_date_fields_insert]
     ON [DNR_Edit].[a483]
     FOR INSERT
AS
BEGIN
     SET NOCOUNT ON;
     UPDATE [DNR_Edit].[a483]
          SET edit_date = getdate()
          WHERE OBJECTID IN (SELECT OBJECTID FROM INSERTED)
     UPDATE [DNR_Edit].[TRIBAL_TRUST_LANDS]
          SET edit_date = getdate()
          WHERE OBJECTID IN (SELECT OBJECTID FROM INSERTED)
     
     UPDATE [DNR_Edit].[a483]
          SET Acres = shape.STArea() * 0.000247105
          WHERE OBJECTID IN (SELECT OBJECTID FROM INSERTED)
     UPDATE [DNR_Edit].[TRIBAL_TRUST_LANDS]
          SET Acres = shape.STArea() * 0.000247105
          WHERE OBJECTID IN (SELECT OBJECTID FROM INSERTED)
END

CREATE TRIGGER [DNR_Edit].[trg_insert_acres_date_fields_update]
     ON [DNR_Edit].[d483]
     FOR UPDATE
AS
BEGIN
     SET NOCOUNT ON;
     UPDATE [DNR_Edit].[a483]
          SET edit_date = getdate()
          WHERE OBJECTID IN (SELECT OBJECTID FROM INSERTED)
     UPDATE [DNR_Edit].[TRIBAL_TRUST_LANDS]
          SET edit_date = getdate()
          WHERE OBJECTID IN (SELECT OBJECTID FROM INSERTED)
     
     UPDATE [DNR_Edit].[a483]
          SET Acres = shape.STArea() * 0.000247105
          WHERE OBJECTID IN (SELECT OBJECTID FROM INSERTED)
     UPDATE [DNR_Edit].[TRIBAL_TRUST_LANDS]
          SET Acres = shape.STArea() * 0.000247105
          WHERE OBJECTID IN (SELECT OBJECTID FROM INSERTED)
END

After making your edits, click the Editor dropdown > Save and the feature classes' fields will update.

All comments

yockee

What if the table is not versioned ? I tried to record changes to a non-versioned table by copying some attributes (non spatial, just ordinary attribute data) to another table using triger (after update) whenever there is update. The trigger works fine on non-spatial table.

vbadugu_royomartin

Can we update directly an attribute on A table or Versioned View on A table trigger for insert? I could see globalids 000000-00000-00000-000000 in A Table and base table after editing any feature in arcgis pro.

What needs to be done to avoid 0's in Global Id field?

AndresCastillo

There's this GIS Stackexchange thread talking about how instead of implementing a trigger on the A&D tables, do it on the versioned view (ie. <TABLE_NAME_EVW>):

editing - ArcSDE 10.1 Insert/Update Trigger on Adds (A) Table (Oracle 11g) and Feature Services on ArcGIS Server - Geogr…

I have yet to try this, but I will verify it because I'm surprised they were able to write to a view (I thought it was read-only, per Oracle):

CREATE TRIGGER

INSTEAD OF Triggers

INSTEAD OF triggers are valid only for views. You cannot specify an INSTEAD OF trigger on a table.
You can read both the :OLD and the :NEW value, but you cannot write either the :OLD or the :NEW value.

In that article, they have lots of good points, including:

Invoking the trigger via the Feature Service query endpoint (https://<machine.domain.com>/webadaptor/rest/services/<folder>/<serviceName>/FeatureServer/0/query) via a web edit post API call.

They mention that if the Geodatabase Version Name parameter is not specified, edits are made to published map's version.

They also mention a cool way to use python to generate unique GUID's similar to Global IDs:

How To: Calculate unique identifier values similar to Global IDs

I believe I ran into your same question on GIS StackEchange as well:

enterprise geodatabase - How to Create 'Update Triggers' to Track Field Values Changes When Data is Versioned? - Geograp…

I did find an Esri documentation saying its ok to grant privileges to a user both on the base table and directly on the versioned view of the table (ie. <TABLE_NAME_EVW>), but that is indeed different than writing to the view:

Privileges for geodatabases in Oracle—Help | ArcGIS Desktop

If the user will be editing versioned data through a versioned view, the user must also be granted SELECT, INSERT, UPDATE, and DELETE privileges on the versioned view.

When you use the Privileges dialog box in ArcGIS to grant the SELECT, INSERT, UPDATE, and DELETE privileges on a versioned feature class, those privileges are automatically granted on the associated versioned view.

Another Esri documentation explains editing versioned views, which I believe applies to update triggers which edit record columns as well:

An overview of editing versioned data using SQL—Help | ArcGIS Desktop

Edit versioned data in Oracle using SQL—Help | ArcGIS Desktop

To edit versioned data from a SQL client, you must edit a versioned view of the data, not the base (business) table itself.

Editing the base table directly could lead to orphaned records and data loss.

AndresCastillo

Beautiful solution for those with workflows that allow registering the FC as versioned with the option "Move Edits to Base"

MikeLachance1

I have a similar question but it also veers a little bit away from what has been discussed here so far.

Using:

ArcGIS Pro
Versioned Database (I am working with and have access to a child checked out from DEFAULT as well as a grandchild (child of child of DEFAULT)
Oracle w/ SDE

My purpose is to design a trigger so that the creation of a new feature in a specified feature class is recorded and stored in a history_tracking_table. A unique ID, the user who made the change, and the change date are captured as well. I have done this and it's functional. See code below:

<SPAN class="keyword token">create</SPAN> <SPAN class="operator token">or</SPAN> replace
<SPAN class="keyword token">trigger</SPAN> insert_obs_history_2
<SPAN class="keyword token">AFTER</SPAN> <SPAN class="keyword token">INSERT</SPAN>
&nbsp; <SPAN class="keyword token">ON</SPAN> A261570
&nbsp; <SPAN class="keyword token">FOR EACH ROW</SPAN>
&nbsp; 
<SPAN class="keyword token">DECLARE</SPAN>
username <SPAN class="keyword token">varchar</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="number token">20</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
prev_Match_Recs number<SPAN class="punctuation token">;</SPAN>

<SPAN class="keyword token">BEGIN</SPAN>
&nbsp; <SPAN class="keyword token">SELECT</SPAN> <SPAN class="token function">COUNT</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="operator token">*</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">INTO</SPAN> prev_Match_Recs
&nbsp; <SPAN class="keyword token">FROM</SPAN> HISTORY_TRACKING_STATE
&nbsp; <SPAN class="keyword token">WHERE</SPAN> HISTORY_ACTION <SPAN class="operator token">=</SPAN> <SPAN class="string token">'INSERTED'</SPAN> <SPAN class="operator token">AND</SPAN>
&nbsp; HISTORY_REPORTID <SPAN class="operator token">=</SPAN> :new<SPAN class="punctuation token">.</SPAN>O_REPORTID<SPAN class="punctuation token">;</SPAN>

<SPAN class="keyword token">IF</SPAN> prev_Match_Recs <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN> <SPAN class="operator token">AND</SPAN>
:new<SPAN class="punctuation token">.</SPAN>O_REPORTID <SPAN class="operator token">IS</SPAN> <SPAN class="operator token">NOT</SPAN> <SPAN class="token boolean">NULL</SPAN> <SPAN class="operator token">AND</SPAN>
:new<SPAN class="punctuation token">.</SPAN>SUBMISSION_STATE_ID <SPAN class="operator token">IS</SPAN> <SPAN class="token boolean">NULL</SPAN> <SPAN class="operator token">AND</SPAN>
:old<SPAN class="punctuation token">.</SPAN>SUBMISSION_STATE_ID <SPAN class="operator token">IS</SPAN> <SPAN class="token boolean">NULL</SPAN>
&nbsp; <SPAN class="keyword token">THEN</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">SELECT</SPAN> <SPAN class="keyword token">USER</SPAN> <SPAN class="keyword token">INTO</SPAN> username <SPAN class="keyword token">FROM</SPAN> dual<SPAN class="punctuation token">;</SPAN>
&nbsp; 
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">INSERT</SPAN> <SPAN class="keyword token">INTO</SPAN> HISTORY_TRACKING_STATE <SPAN class="keyword token">VALUES</SPAN> <SPAN class="punctuation token">(</SPAN>
&nbsp;&nbsp;&nbsp; :new<SPAN class="punctuation token">.</SPAN>O_REPORTID<SPAN class="punctuation token">,</SPAN> :new<SPAN class="punctuation token">.</SPAN>SUBMISSION_STATE_ID<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp; username<SPAN class="punctuation token">,</SPAN> SYSTIMESTAMP<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'INSERTED'</SPAN> <SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
&nbsp; <SPAN class="keyword token">END</SPAN> <SPAN class="keyword token">IF</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">END</SPAN><SPAN class="punctuation token">;</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

My question is: How do I create an 'update' trigger to capture when the 'SUBMISSION_STATE_ID' field changes if my data is versioned? I am not able to run an UPDATE trigger and grab ':new' and ':old' values because with versioning the change in the field value is just an addition to the A#### table. I would like to be able to compare the old and new value of this field when it is changed to make sure they are not the same.

Any ideas?

ThomasColson

This is all possible with before begin statement, you just need to build the conditions that must be TRUE before BEGIN. I've done something like that before, I just can't seem to find it now....try just after insert, drop the update.

PriscillaThoopthong1

Thanks but I don't want it to fire if the shape is moved either. I only want it to fire when the feature is first created. Actually I only want it to fire AFTER they've added a new feature and AFTER they've saved their edits but I think I'm asking too much of ESRI now

And then I have another trigger that I want to fire ONLY the first time a particular attribute is changed and ONLY that particular attribute and ONLY AFTER they've saved their edits.

ThomasColson

AFTER INSERT, UPDATE
AS

BEGIN
SET NOCOUNT ON;
IF UPDATE ([SHAPE])
BEGIN

will only fire your trigger if a new feature is added, or the shape is edited (e.g moved). It will not fire on just an attribute edit.

PriscillaThoopthong1

Whenever something is updated, SDE inserts into the A table, so that means even if you're just updating an attribute it gets inserted into the A table. So if you trigger is FOR INSERT, it will fire the trigger even when updating.

I only want my trigger to fire when they add a feature. Is there a way to do this? I tried doing a count in the trigger to see if there were other rows in the table with the same OBJECTID and that works great until I try to reconcile and then I get a mutating error. Is there another way?

ThomasColson

Based on your statement that you're only using the default version, and, emphasis on, this is my personal opinion, register the FC with "Move Edits to Base", and don't worry about triggers on the A table at all, put the trigger directly on the FC table. During an edit session, you won't see the trigger fire 'till you hit "Save Edits". That's my work flow, at least. Most of my editing is distributed (via AGISSvr Feature Service local copy for editing), and any attributing that is done by triggers is done on the backend like this. Why I like this way, is, if I ever have to unregister the FC to not-versioned, when the A table get's deleted, I don't lose a trigger I spend 2 weeks trying to get to work.

JoeBorgione

I've used the same trigger on th A table only for years. Never worried about the D table. If the record has been deleted, what's left to modify with a trigger?

RobertScheitlin__GISP

Jake,

Yep that is why I said it is marked for deletion. Anyway I thought that I should clarify your statement.

D table for updates (moving/modifying features/attributes)

But now I think I understand that you were saying that a trigger needs to be added to this table for when the featureclass has a feature modified in some way and then the trigger will update the "a" table.

jskinner

Hi Robert,

After an update, the original is not deleted. Here is a screen shot of the A & D table after the same feature has been updated 4 times:

I originally was receiving an error, "connection is busy from results for another command", when trying to perform the INSERT and UPDATE on the A table. That is why I suggested to create the UPDATE on the D table. A second test, and this appears to be working with just creating the INSERT, UPDATE trigger on the A table. Not sure why I was receiving this error before.

RobertScheitlin__GISP

Jake,

The D table hold just the deletes for the versioned FC it only has three columns SDE_STATE_ID, SDE_DELETES_ROW_ID, and DELETED_AT columns. When and edit or update occurs the original is marked for deletion and a new row is added to the A Table.

jskinner

Hi Lisa,

To find the A and D table, you can query the table_registry table:

select registration_id from sde.sde_table_registry where table_name = 'TRIBAL_TRUST_LANDS'

Note: If you are using a DBO schema, change sde.sde_table_registry to dbo.sde_table_registry.

This query will return the registration_id that you can use to query the A & D tables. Ex:

DNR_Edit.a483

DNR_Edit.d483

You can then create the triggers on each of these tables:

CREATE TRIGGER [DNR_Edit].[trg_insert_acres_date_fields_insert]
     ON [DNR_Edit].[a483]
     FOR INSERT
AS
BEGIN
     SET NOCOUNT ON;
     UPDATE [DNR_Edit].[a483]
          SET edit_date = getdate()
          WHERE OBJECTID IN (SELECT OBJECTID FROM INSERTED)
     UPDATE [DNR_Edit].[TRIBAL_TRUST_LANDS]
          SET edit_date = getdate()
          WHERE OBJECTID IN (SELECT OBJECTID FROM INSERTED)
     
     UPDATE [DNR_Edit].[a483]
          SET Acres = shape.STArea() * 0.000247105
          WHERE OBJECTID IN (SELECT OBJECTID FROM INSERTED)
     UPDATE [DNR_Edit].[TRIBAL_TRUST_LANDS]
          SET Acres = shape.STArea() * 0.000247105
          WHERE OBJECTID IN (SELECT OBJECTID FROM INSERTED)
END

CREATE TRIGGER [DNR_Edit].[trg_insert_acres_date_fields_update]
     ON [DNR_Edit].[d483]
     FOR UPDATE
AS
BEGIN
     SET NOCOUNT ON;
     UPDATE [DNR_Edit].[a483]
          SET edit_date = getdate()
          WHERE OBJECTID IN (SELECT OBJECTID FROM INSERTED)
     UPDATE [DNR_Edit].[TRIBAL_TRUST_LANDS]
          SET edit_date = getdate()
          WHERE OBJECTID IN (SELECT OBJECTID FROM INSERTED)
     
     UPDATE [DNR_Edit].[a483]
          SET Acres = shape.STArea() * 0.000247105
          WHERE OBJECTID IN (SELECT OBJECTID FROM INSERTED)
     UPDATE [DNR_Edit].[TRIBAL_TRUST_LANDS]
          SET Acres = shape.STArea() * 0.000247105
          WHERE OBJECTID IN (SELECT OBJECTID FROM INSERTED)
END

After making your edits, click the Editor dropdown > Save and the feature classes' fields will update.

RobertScheitlin__GISP

Lisa,

I have not actually worked with adding triggers in SQL Server SDE but I do have some advice about what your issue likely is. The thing to understand about a versioned FeatureClass in SDE is that once a FC is versioned it has three (important) tables that it will use when versioning. There is the Business table likely the one you are editing and the Adds table (a table that holds all the new and edited features that will get moved to the business table once the compress is completed) like the one you need to be editing and the Deletes table that contains a list of feature that are to be deleted when the next compress occurs. So in your workflow you are likely editing the business table and the compress has not occurred yet and when the feature is requested from SDE it is actually getting the Adds table row for that feature and thus you do not see your changes. You can look at the table registry (sde.SDE_Table_Registry) in your geodatbase to determine the name of the adds table for your particular FC (something like DBOwner.a52). The registration_id field will have the number of the a table based on the name of your FC in the table_name column. If you add the trigger to the a table then you will see the edit immediately in ArcGIS and it will be committed to the business table for the FC when the Geodatabase is compressed.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.