cancel
Showing results for 
Search instead for 
Did you mean: 

This entry already exists in the following tables (ODBC -2035)

Former Member
0 Kudos

When i try to update BP without do any changes in the object i receive this error message.

SBO version 2005B SP00 PL 34

Interop.SAPbobsCOM.dll 2005 (C#.net)

tks!

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

i receive this error message when i try to update BPFiscalTaxID...


if (tipo == BoAddressType.bo_ShipTo)
        {
            contFiscTax++;

            if (contFiscTax <= oBusinessPartners.FiscalTaxID.Count)
            {
                //localiza o endereço referente a estes dados fiscais
                for(int x = 0; x < oBusinessPartners.FiscalTaxID.Count;x++)
                {
                    if (oBusinessPartners.FiscalTaxID.Address.Equals(oBusinessPartners.Addresses.AddressName))
                    {
                        oBusinessPartners.FiscalTaxID.SetCurrentLine(x);
                        x = oBusinessPartners.FiscalTaxID.Count;
                    }
                }
                
            }
            else
                oBusinessPartners.FiscalTaxID.Add();   

            if (endTO.IdentFiscal.CNAEId != null && !endTO.IdentFiscal.CNAEId.Equals(""))
                oBusinessPartners.FiscalTaxID.CNAECode = Convert.ToInt32(endTO.IdentFiscal.CNAEId);
            
            oBusinessPartners.FiscalTaxID.Address = endTO.Address;
            oBusinessPartners.FiscalTaxID.TaxId0 = endTO.IdentFiscal.TaxId0;
            oBusinessPartners.FiscalTaxID.TaxId1 = endTO.IdentFiscal.TaxId1;
            oBusinessPartners.FiscalTaxID.TaxId2 = endTO.IdentFiscal.TaxId2;
            oBusinessPartners.FiscalTaxID.TaxId3 = endTO.IdentFiscal.TaxId3;
            oBusinessPartners.FiscalTaxID.TaxId4 = endTO.IdentFiscal.TaxId4;
            oBusinessPartners.FiscalTaxID.TaxId5 = endTO.IdentFiscal.TaxId5;
            oBusinessPartners.FiscalTaxID.TaxId6 = endTO.IdentFiscal.TaxId6;
            oBusinessPartners.FiscalTaxID.TaxId7 = endTO.IdentFiscal.TaxId7;
            oBusinessPartners.FiscalTaxID.TaxId8 = endTO.IdentFiscal.TaxId8;
        }

what is wrong with this code? i alter the FiscalTaxID data when the oBusinessPartners.Addresses whas changed...

Former Member
0 Kudos

the api does not load the fiscaltaxid propertie when the business partner whas load... the field fiscaltaxid.address came empty...

i think that is a bug of DI API....

Former Member
0 Kudos

its a bug of my head XD

i did'nt used the setCurrentLine method...

oBusinessPartners.FiscalTaxID.SetCurrentLine(x);....

but now icontinue having the same problem.... This entry already exists in the following tables (ODBC -2035).....

Former Member
0 Kudos

sounds like you need to remove the reference to the bobscom dll and then add it as a component again.

either that or reinstall the diapi on the client.

Former Member
0 Kudos

John,

Me to have the same problem. My screen is userdefined. As u said i remove dll and ref but same result.

Iam using SAP 2005 PL 05.

How to Solve this??

Regards,

Anitha