Select to view content in your preferred language

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

3816
2
Jump to solution
09-23-2013 02:14 PM
PeterTimmers
Frequent Contributor
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
0 Kudos
1 Solution

Accepted Solutions
PeterTimmers
Frequent Contributor
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.

View solution in original post

0 Kudos
2 Replies
AkhilParujanwala
Regular Contributor
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.
0 Kudos
PeterTimmers
Frequent Contributor
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.
0 Kudos