How to handle log table of the child table in Master data UDO through code

[Former Member]

Hi experts,

I have a child table in a master data UDO.

The child table is bound with a matrix. During Add/Update, a blank record also is been created in the concerned table corresponding to the child table. I solved the issue by removing the blank record from the DB data source at the item event for ADD/UPDATE.

*But the blank record is being created in the log table for the child table.* Which i cannot remove. First of all I want to know whether the same is possible or not. If you feel it is possible, please suggest me the solution.

Thanks in advance,

Regards

Pradeep

[Former Member]

Hi pradeep,

I use the same approach has you and I don't have blank records in the UDO child log table.

Best Regards,

Vítor Vieira

[Former Member]

Hi Pradeep,

Your issue is insert the blank record in the table(i.e. in detail table). The issue is comes by adding extra row in the matrix.

Instead of to solve the issue by DB data source at the item event for ADD/UPDATE

you remove the extra row inserted in the matrix as oMatrix.DeleteRow(oMatrix.RowCount) at the item event for ADD/UPDATE and beforeaction=true

So that there is no extra row insert in the details table and also in log table.

Thanks,

Mahesh