Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

delete data from table control and delte multiple data from database

Former Member

‎12-21-2012 4:53 AM

0 Kudos

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

2 REPLIES 2

kakshat
Advisor
Advisor

‎12-21-2012 5:01 AM

0 Kudos

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?

kakshat
Advisor
Advisor
In response to kakshat

‎12-21-2012 5:04 AM

0 Kudos

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'.