Skip to Content
avatar image
Former Member

UPDATE Or COPY through SQL in a UDT

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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

    • 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