topic Re: Web Appbuilder and SQL Server sequences issue in ArcGIS Web AppBuilder Questions https://community.esri.com/t5/arcgis-web-appbuilder-questions/web-appbuilder-and-sql-server-sequences-issue/m-p/734449#M19403 <HTML><HEAD></HEAD><BODY><P>Oh for the love of Pete . . . . yet again "can't do that with ArcAnything"...</P><P></P><P></P><P><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">NIM083213 :&nbsp; Allow support of SQL Server Sequences with ArcSDE.</SPAN></P><P></P><P><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">Public explanation: Auto-populated fields such as identity or sequence-generated are not supported by core-geodatabase model.</SPAN></P><P></P></BODY></HTML> Wed, 07 Oct 2015 19:48:16 GMT VenusScott 2015-10-07T19:48:16Z Web Appbuilder and SQL Server sequences issue https://community.esri.com/t5/arcgis-web-appbuilder-questions/web-appbuilder-and-sql-server-sequences-issue/m-p/734448#M19402 <HTML><HEAD></HEAD><BODY><P>I'm trying to use a SQL Server 2012 "sequence" value as the binding value for a field:</P><P><IMG __jive_id="129720" alt="" class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/129720_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P>If I enter a record using the command line method, it adds the record with the values just fine (Junk Record 4):</P><P><IMG __jive_id="129721" alt="" class="image-2 jive-image" src="https://community.esri.com/legacyfs/online/129721_pastedImage_1.png" style="max-width: 1200px; max-height: 900px;" /></P><P>But if I use Web Appbuilder it does not insert the NEXT VALUE FOR (Junk Record 5):</P><P><IMG alt="" class="image-3 jive-image" src="https://community.esri.com/legacyfs/online/129780_pastedImage_1.png" style="max-width: 1200px; max-height: 900px;" /></P><P>I also noticed that the <STRONG>field</STRONG> with the "Default Value or Binding" MUST allow NULL values or Web AppBuilder will not insert the record!</P><P></P><P>Any one else using sequences in SQL Server and run across this issue? Solution?</P><P></P><P>I'm more of an Oracle database user so don't use SQL Server "big words" on me . . . LOL!</P></BODY></HTML> Mon, 05 Oct 2015 16:57:15 GMT https://community.esri.com/t5/arcgis-web-appbuilder-questions/web-appbuilder-and-sql-server-sequences-issue/m-p/734448#M19402 VenusScott 2015-10-05T16:57:15Z Re: Web Appbuilder and SQL Server sequences issue https://community.esri.com/t5/arcgis-web-appbuilder-questions/web-appbuilder-and-sql-server-sequences-issue/m-p/734449#M19403 <HTML><HEAD></HEAD><BODY><P>Oh for the love of Pete . . . . yet again "can't do that with ArcAnything"...</P><P></P><P></P><P><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">NIM083213 :&nbsp; Allow support of SQL Server Sequences with ArcSDE.</SPAN></P><P></P><P><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">Public explanation: Auto-populated fields such as identity or sequence-generated are not supported by core-geodatabase model.</SPAN></P><P></P></BODY></HTML> Wed, 07 Oct 2015 19:48:16 GMT https://community.esri.com/t5/arcgis-web-appbuilder-questions/web-appbuilder-and-sql-server-sequences-issue/m-p/734449#M19403 VenusScott 2015-10-07T19:48:16Z