Skip to Content
avatar image
trying to

UPDATE Or COPY through SQL in a UDT

Sep 09, 2017 at 02:39 PM | 76 Views

Hello,

How can i delete or copy data from one Column into another one ( Or simply delete Data ) in a UDT ?

I have more than 3000 Data entries in a UDT that i need to delete or to copy data from one Column into another so that my Query works.

is that possible through UPDATE or DELETE in a Query?

SAP Business One
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    DIEGO LOTHER
    Sep 09, 2017 at 08:55 PM

    Hi muhammed,

    Look this explanation of what is allowed.

    https://blogs.sap.com/2016/07/28/guidelines-for-modifying-sap-business-one-data/

    Hope it helps.

    Kind Regards.

    Diego Lother

    Add comment
    10|10000 characters needed characters exceeded

    • DIEGO LOTHER trying to
      Sep 10, 2017 at 09:46 PM

      Hi Muhammed,

      Did you execute your query on sql management studio?

      The delete instruction cannot contain "*", then the correct query should be:

      DELETE FROM [@myTable] WHERE .....

      If you execute your query on sql management studio you are able to see the correct error message or a successful message.

      Hope it helps.

      Kind Regards,

      Diego Lother