I'm trying to use a SQL Server 2012 "sequence" value as the binding value for a field:
If I enter a record using the command line method, it adds the record with the values just fine (Junk Record 4):
But if I use Web Appbuilder it does not insert the NEXT VALUE FOR (Junk Record 5):
I also noticed that the field with the "Default Value or Binding" MUST allow NULL values or Web AppBuilder will not insert the record!
Any one else using sequences in SQL Server and run across this issue? Solution?
I'm more of an Oracle database user so don't use SQL Server "big words" on me . . . LOL!
Solved! Go to Solution.
Oh for the love of Pete . . . . yet again "can't do that with ArcAnything"...
NIM083213 : Allow support of SQL Server Sequences with ArcSDE.
Public explanation: Auto-populated fields such as identity or sequence-generated are not supported by core-geodatabase model.
Oh for the love of Pete . . . . yet again "can't do that with ArcAnything"...
NIM083213 : Allow support of SQL Server Sequences with ArcSDE.
Public explanation: Auto-populated fields such as identity or sequence-generated are not supported by core-geodatabase model.