Skip to Content
avatar image
Former Member

"The Entry Already Exists (ODBC-2035) [Message 131-183]"

Dear Experts,

In a user defined form when in form Mode "Add" all operations are going right.But after addition when I try to add a row in the matrix ,update mode and after filling it.When I press Update button I get a error. "The Entry Already Exists (ODBC-2035) [Message 131-183]"

Edited by: Er.Manish Srivastava on Feb 17, 2012 10:14 AM

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Feb 17, 2012 at 09:46 AM

    Hi Manish,

    please clear all variables, before assigning it to matrix.

    this error is showing because records are getting updated in same row...

    Thanks and Regards,

    kaviprashu

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Sir Do I have to clear all the matrix data .Than all data are lost. Means I have to create a temporary table. And then reload the Matrix.

  • avatar image
    Former Member
    Feb 17, 2012 at 11:27 AM

    We can try this:

    oForm.Datasources.DBDatasources.Item("@table").Clear()

    oMatrix.AddRow()

    oMatrix.FlushToDataSource()

    Add comment
    10|10000 characters needed characters exceeded

    • you need not to put that data in any Temp table. When you click on update button.Write in BeforeAction = True event.

      First delete all the data from the Matrix table using Query, then the updation will take place automatically.

  • avatar image
    Former Member
    May 07, 2014 at 01:38 AM

    Hello,

    We encountered the same error but, it was on creating batch transaction on GRPO or Receipt for Production, were using SAP Business One 8.81 (8.81.312) PL: 04. Can you please enlighten, because I cannot understand what table need the clearing.

    I know that OBTN is where the batch data stored.

    Regards,

    Ellie

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 19, 2014 at 10:00 AM

    When I clear table on  SAP B1 and object , it works , but I suppose it exists another solution !!!!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 19, 2016 at 07:29 AM

    try this:

    If pval.Before_Action = True Then

                    Select Case pval.ItemUID

                        Case "1"

                            If oForm.Mode = SAPbouiCOM.BoFormMode.fm_ADD_MODE Or oForm.Mode = SAPbouiCOM.BoFormMode.fm_UPDATE_MODE Then

                                oForm = oApplication.Forms.ActiveForm()

                                oMatrix = oForm.Items.Item("3").Specific

                                For i As Integer = 1 To oMatrix.RowCount

                                    If oMatrix.Columns.Item("ColUID").Cells.Item(i).Specific.value = "" Then

                                        oMatrix.DeleteRow(i)

                                    End If

                                Next

                            End If

                    End Select

                End If

    Add comment
    10|10000 characters needed characters exceeded