SQL Trigger on Insert in ArcSDE Not Showing

MeleKoneya — Mon, 06 Mar 2017 17:07:07 GMT

I have created a Trigger in SQL to update a field called asset_id.

It does work, but I can't see the value until after I save the edit in ArcMap and stop editing. I am also wanting to see the new asset_id value in ArcGIS WebAppbuilder, but I don't see it until after I exit the app and reopen it.

The Feature Class is versioned as in ArcSDE 10.2.2 on SQL Server 2014.

I do not have the 'Save Edits to Base' option checked.

Why am I not able to see the edits as soon as they are made on an Insert?

CREATE TRIGGER [sde].[trg_insert_asset_id]

ON [sde].[a98]

AFTER INSERT

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with SELECT statements.

SET NOCOUNT ON;

-- Insert statements for trigger here

DECLARE @id int

--PRINT @ReturnValue

UPDATE [dbo].[Sequences]

SET next_id = next_id + 1

WHERE sequenceName = 'ASSETID'

SET @id = (SELECT next_id

FROM [dbo].[Sequences]

WHERE sequenceName = 'ASSETID')

UPDATE s

SET Asset_ID = @id

FROM preserve.sde.a98 s, inserted

WHERE s.OBJECTID = inserted.OBJECTID

END

topic SQL Trigger on Insert in ArcSDE Not Showing in Geodatabase Questions

SQL Trigger on Insert in ArcSDE Not Showing