AnsweredAssumed Answered

Web Appbuilder and SQL Server sequences issue

Question asked by vscott1 on Oct 5, 2015
Latest reply on Oct 7, 2015 by vscott1

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!

Outcomes