Web Appbuilder and SQL Server sequences issue

2746
1
Jump to solution
10-05-2015 09:57 AM
VenusScott
Occasional Contributor III

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!

0 Kudos
1 Solution

Accepted Solutions
VenusScott
Occasional Contributor III

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.

View solution in original post

0 Kudos
1 Reply
VenusScott
Occasional Contributor III

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.

0 Kudos