Populate ID with value from Oracle Sequencer

JoseSanchez — Tue, 18 Oct 2016 13:35:46 GMT

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

topic Populate ID with value from Oracle Sequencer in ArcGIS Online Developers Questions

Populate ID with value from Oracle Sequencer