topic delete data from table control and delte multiple data from database in Application Development and Automation Discussions

delete data from table control and delte multiple data from database

Former Member — Fri, 21 Dec 2012 04:53:14 GMT

hi guys,

i am not able to delete data from internal table . i have declared mark eq 'X' its not holding mark value as 'X'.

LOOP AT t_lopout INTO w_lopout WHERE mark = 'X'.

DELETE t_lopout FROM w_lopout.

ENDLOOP.

dis is wat i wrote bnut its not working...pls reply

Moderator message : Search for available information, discussion locked.

Message was edited by: Vinod Kumar

Re: delete data from table control and delte multiple data from database

kakshat — Fri, 21 Dec 2012 05:01:06 GMT

What do you mean by it's not holding mark value as 'X'? Are you saying that you are not able to set the value for column MARK as 'X' in internal table t_lopout?

Re: delete data from table control and delte multiple data from database

kakshat — Fri, 21 Dec 2012 05:04:07 GMT

By the way, it's not a good practice to be looping over a table deleting contents from the same table within the loop.

Instead, since you have a MARK column, you can use the DELETE WHERE statement.

DELETE t_lopout WHERE mark = 'X'.