Skip to Content
avatar image
Former Member

DELETE RECORDS FROM A TABLE VARIABLE

Hi All,

What is the syntax for deleting records from a table type variable?

The statement DELETE FROM :TABLE_1; is giving a syntax error when used in the script based calc view.

Goutham

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jul 24, 2014 at 03:20 AM

    You can not do DELETE, INSERT on intermediate table variables.

    Specify your exact requirement why you want to DELETE on intermediate table variable.

    If you want to delete certain rows then you must write it as SELECT condition itself.

    Add comment
    10|10000 characters needed characters exceeded