on 07-23-2014 11:04 PM
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.