cancel
Showing results for 
Search instead for 
Did you mean: 

This already exists in the following tables @Table (ODBC 2035) msg [131-183

luisherrera2
Explorer
0 Kudos

Hi everybody;

Can some expert help me? I'm developed a addon by SDK and .Net and i created this user tables master(Form 1) and document (Form2) type, header and lines for each one and when i tried update some fields for example: description, quantity and others in the header or some details lines and columns, show me the next message error:

This already exists in the following tables "@Table (ODBC 2035) message [131-183]

My SAP B1 version is 2007A, SP1 PL6 and SQL Server 2005.

Regards,

Luis Herrera

SAP B1 Consultant

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Luis,

How many UDT do you want to update?

Thanks,

Gordon

luisherrera2
Explorer
0 Kudos

Hi Gordon;

Thank's you for your rapid response. Currently i need update some fields in only one User Definied Table of type master(header and lines), my addon have a following workflow:

Form1(UDT @REQC) --> Form2 (UDT @SOLC), when i need update some fields in a @SOLC for example description, attachment in a tab details or number of due dates (this is a user definied field in a header form2).

This addon is for purchase requirements and next when this is approve in other form selections. I can create a Solicitud from requirements approved (this Solicitud is create from Form2) and follow the users would need updates some fields in the form2 but not is posible because when i tried update some fields show me message error postead.

Regards,

Luis Herrera

Former Member
0 Kudos

What is the relationship between UDT @REQC and UDT @SOLC?

luisherrera2
Explorer
0 Kudos

Gordon;

This UDTs aren't relationship, only complete data in the table @SOLC by SQL Transact. The Solicitud form (@SOLC) is a object of master type, where the data are registred by SQL.

Regards,

Luis Herrera

Former Member
0 Kudos

Your question belongs to SDK forum. Better close this one and post it there.