Skip to Content
avatar image
Former Member

B1if | Remove/Update row from UDO child tables

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 26, 2017 at 03:01 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 24, 2017 at 11:37 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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