B1if | Remove/Update row from UDO child tables

[Former Member]

Hi experts,

I am using the DI API General Service from B1if to add, remove and update the information of UDO and works fine. But so far, I can't find the way to remove/update an specific line of an UDO child table. Some help would be great.

Thanks in advance,

Gabriela

[Former Member · Accepted solution]

Hi All,

Finally didn't work for me using the B1 Service call atom. To get a solution, I developed a .dll using the DI API and I am calling it from B1if using the .NET call atom. Hope the B1if teams work on this in the future.

Best regards,

Gabriela

[Former Member]

Hi Gabriela,

It would be very interesting to know, if it possible to solve your problem via DI API.

In similar situation we have used direct SQL statement (using Call SQL atom). It is probably not accurate solution, but it works.

Good luck,

Ildar

[Former Member]

Hi Ildar Islamgazin,

Thanks for your answer. I have been researching about this for a while. Using only the DI-API it is possible with the GeneralService, but I needed to do this from B1if. The solution I found is update the whole child table everytime with the B1 Service atom call using the same GeneralService. The only problem is that I cant reset the LineId's in this way. Using the SQL call atom is not secure in this case because this is related to an UDO in the database, so there could be license issues if you update or insert using sql calls.

Best regards,

Gabriela