Populate ID with value from Oracle Sequencer

426
0
10-18-2016 06:35 AM
JoseSanchez
Occasional Contributor III

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

0 Kudos
0 Replies