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

[Former Member]

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

[former_member496299]

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

[Former Member]

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

[former_member629222]

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

[former_member629222]

Can that clearing command can be done on sqlserver 2008? If ever can is the sytntax?

Regards,

[Former Member]

We can try this:

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

oMatrix.AddRow()

oMatrix.FlushToDataSource()

[Former Member]

Hi Manish,

Sorry for late reply,

you don't need create or clear existing tables.

all you need to check is whether the variables you used in program is getting updated or not.

it may happen that variables holding values of primary key is not getting cleared in loop..

pls put a break-point in loop, and then check the varaiables of recordset and matrix values...

Thanks and Regards,

kaviprashu

[Former Member]

thanks

[ANKIT_CHAUHAN]

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.

[Former Member]

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

[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.