topic Re: delete row in itab in Application Development and Automation Discussions

delete row in itab

Former Member — Wed, 21 Mar 2007 11:16:20 GMT

Hallow

I wont to delete from my internal table value with persg <> 6 or 7 or 8

I try like that but it delete data in my table with persg 6 7

How I can delete all the row in my table with 6, 7,8 in persg

This is my trying

and its not working

DELETE person_tab WHERE ( persg <> 6 OR persg <> 7 OR persg <> 8 ).

regards

Former Member — Wed, 21 Mar 2007 11:22:40 GMT

hi,

do this way

DELETE person_tab WHERE ( persg <>' 6'  OR persg <> '7' OR persg <>' 8' ).

Regards,

Santosh

Former Member — Wed, 21 Mar 2007 11:22:48 GMT

DELETE person_tab WHERE ( persg <> 6 AND persg AND 7 OR persg AND 8 )

is the correct one...

reward if helpful...

Former Member — Wed, 21 Mar 2007 11:23:14 GMT

Try this..

DELETE person_tab WHERE ( persg <> '6' OR persg <> '7' OR persg <> '8' ).

Reward points if useful...

Cheers,

Sam

alex_m — Wed, 21 Mar 2007 11:24:38 GMT

Try this,

DELETE person_tab WHERE ( persg <> 6 AND persg <> 7 AND persg <> 8 ).

Former Member — Wed, 21 Mar 2007 11:24:49 GMT

Hi,

write:

DELETE person_tab WHERE ( persg >= 6 and persg <= 8 )

you can put them in range and write:

DELETE person_tab WHERE persg in r_numbers.

or write 3 times:

DELETE person_tab WHERE persg = 6.

DELETE person_tab WHERE persg = 7.

DELETE person_tab WHERE persg = 8.

regards,

Anji