topic SQL Insert After Trigger not working correctly with inserted ArcGIS Mobile records in ArcGIS for Windows Mobile Questions

SQL Insert After Trigger not working correctly with inserted ArcGIS Mobile records

PeterTimmers — Mon, 23 Sep 2013 21:14:21 GMT

If you add a record to arcgis mobile then synchronise it, it appears you aren't getting a proper insert after event.

The inserted record doesn't have any geometry.

If I add the point in ArcMap it all works like it should with the geometry existing in inserted.

Would it be that the geometry is added after the initial insert in an update?

No versioning involved here. ArcGIS Mobile 10.1.1 and Server 10.1

Re: SQL Insert After Trigger not working correctly with inserted ArcGIS Mobile record

AkhilParujanwala — Wed, 25 Sep 2013 14:19:19 GMT

This is just a guess but it seems like you are not creating the features in your Mobile App correctly.
Maybe there is something wrong with your code?
How about making a mobile project using the Project Center and creating quick test application.
I do this quite often to test new features with certain feature classes.

I personally don't register my feature classes as versioned.
When I sync I have no problems. However, I am still using ArcGIS 10.0. We have some plans in the future to move to 10.1 or 10.2.

Re: SQL Insert After Trigger not working correctly with inserted ArcGIS Mobile record

PeterTimmers — Wed, 25 Sep 2013 21:13:39 GMT

Well I solved it in the end by having both an insert and update after trigger.

As far as I can see ArcGIS Mobile inserts a row, but then adds the data in a seperate step.

I had to use the insert after to make a new row in the second table, copy the globalid across so I could do a join back when the update comes through so I could do an update after and copy the data across.

Seems to work smoothly. If anyone knows a better way please tell me.