UDO - Error

[Former Member]

Dear Members,

I have created an UDO for an user defined form.The user defined from contains matrix.

If i add data in the matrix and try to update the user defined form.

Ii get an error named "This entry already exists in the table"

[Former Member · Accepted solution]

Hi,

This is a known issue when ur working with UDO. U'll get this error when ur updating. The problem is with the data sources.

Check the following threads which would help solve the issue..

(This has a code sample which i posted previously.)

Regards,

Vasu Natari.

[Former Member · Accepted solution]

Hi Vasu,

I tried all your suggestions. But the problem still remains.

I want to make some points clear.

I am using 2007B. My UDO contains one header table of type Document and 5 child tables of type DocumentLines. I created the UDO through vb.net coding. The UDO registered successfully and its working fine in Add Mode.

But in Update mode if I add rows in matrix which is connected with child table I get this error This entry already exists in the following tables(ODBC-2035)[[Message 131-183]]

Please help in this regard.

Regards,

Tamizharasi.S

[Former Member · Accepted solution]

Hi,

When i get this error what i do is... i clear the data sources... then in the before action = true i delet all the lines in the child tables.

So when the system updates the table will be empty so u'll not get that error..

Did u try this..??

Vasu Natari.

[Former Member · Accepted solution]

Thanks a lot.

Problem got solved.