topic Re: delete statement in Application Development and Automation Discussions

delete statement

Former Member — Mon, 16 Jul 2007 09:47:17 GMT

experts can anyone please tell me the syntax of delete statament.actually my code is not running and is giving a shortdump.

DELETE itab WHERE emo_cd_rd_dest = 2314.

is there any alternate mthod fot this.

Re: delete statement

Former Member — Mon, 16 Jul 2007 09:48:35 GMT

Hi,

what is the error message in shortdump?

Re: delete statement

former_member491305 — Mon, 16 Jul 2007 09:48:36 GMT

Hi,

Give it in codes.

DELETE itab WHERE emo_cd_rd_dest = '2314'.

Re: delete statement

former_member404244 — Mon, 16 Jul 2007 09:49:48 GMT

Hi,

Try like this.use single code.

DELETE itab WHERE emo_cd_rd_dest = '2314'.

Regards,

Nagaraj

Re: delete statement

Former Member — Mon, 16 Jul 2007 09:50:44 GMT

Hi,

Try this,

DELETE itab WHERE emo_cd_rd_dest = '2314'.

What dump it is Showing?

Regards,

Padmam.

Re: delete statement

Former Member — Mon, 16 Jul 2007 10:01:51 GMT

Hi Gaurav

You can also use Clear or else you can also delete by comparing

DELETE ADJACENT DUPLICATES FROM itab.

DATA ITAB LIKE STANDARD TABLE OF LINE 
          WITH NON-UNIQUE KEY COL2.

LINE-COL1 = 1. LINE-COL2 = 'A'. APPEND LINE TO ITAB.
LINE-COL1 = 1. LINE-COL2 = 'A'. APPEND LINE TO ITAB.
LINE-COL1 = 1. LINE-COL2 = 'B'. APPEND LINE TO ITAB.
LINE-COL1 = 2. LINE-COL2 = 'B'. APPEND LINE TO ITAB.
LINE-COL1 = 3. LINE-COL2 = 'B'. APPEND LINE TO ITAB.
LINE-COL1 = 4. LINE-COL2 = 'B'. APPEND LINE TO ITAB.
LINE-COL1 = 5. LINE-COL2 = 'A'. APPEND LINE TO ITAB.

OFF = 0. PERFORM LIST.

DELETE ADJACENT DUPLICATES FROM ITAB COMPARING ALL FIELDS.

OFF = 14. PERFORM LIST.

DELETE ADJACENT DUPLICATES FROM ITAB COMPARING COL1.

OFF = 28. PERFORM LIST.

DELETE ADJACENT DUPLICATES FROM ITAB.

OFF = 42. PERFORM LIST.

FORM LIST.
  SKIP TO LINE 3.
  LOOP AT ITAB INTO LINE.
     WRITE: AT /OFF  LINE-COL1, LINE-COL2.
  ENDLOOP.
ENDFORM.

Reward all helpfull answers

Regards

Pavan