Skip to Content
0
Former Member
Oct 16, 2007 at 08:47 AM

how to delete record

13 Views

hi

there is a record in internal table as below

210 |0000000110|AGILENT TECHNOLOGIES <TEST1 <

210 |0000000110|AGILENT TECHNOLOGIES <TEST2 <

210 |0000000110|AGILENT TECHNOLOGIES <TEST3 <

210 |0000000110|AGILENT TECHNOLOGIES <TEST4TOTEST5 <

and there are recored in table having all fields as primary key ie it has these above 3 fields as primary key and record is like t his

210 |0000000110|AGILENT TECHNOLOGIES <TEST1 <

210 |0000000110|AGILENT TECHNOLOGIES <TEST2 <

210 |0000000110|AGILENT TECHNOLOGIES <TEST3 <

<b>210 |0000000110|AGILENT TECHNOLOGIES <TEST4 <</b>

210 |0000000110|AGILENT TECHNOLOGIES <TEST4TOTEST5 <

i want to delted the bolded r ecored ie test 4 and when i am using the below statement

delete from zcustemail

where ship_to = t_zcust_em-ship_to

AND SHIP_TO_NAME = t_zcust_em-ship_TO_NAME

ANd EMAIL_ID <> t_zcust_em-EMAIL_ID.

it is not working fine

pls suggest how to delte the recroed which are not in the internal table...

regards

Arora