Hello everyone,
Using the edit widget in Web AppBuilder is there a way to configure the Editor Widget to populate a field "AssetID" with a value obtained from a Oracle Sequencer.
I am able to do that in an Vb.Net add-In and also I could do that in the old Web ADF, using this code:
Function NextFeatureClassNumber() As Integer
.......
' Find Next FeatureClassID
'
'
' Call Oracle Sequencer FeatureClass_SEQ
Dim FeatureClassConn As String = section.ConnectionStrings("FeatureClassConnectionString").ConnectionString
Dim nextFeatureClass As Integer = 0
Dim connection As New OracleConnection(FeatureClassConn)
Dim command As New OracleCommand("SELECT FeatureClass_SEQ.NextVal FROM DUAL", connection)
Try
connection.Open()
nextFeatureClass = CType(command.ExecuteScalar(), Integer)
connection.Close()
Catch ex As Exception
MsgBox("Error: " & ex.Message, MsgBoxStyle.Critical, "FeatureClassEditorExtension")
End Try
Return nextFeatureClass
End Function