Delete

[Former Member]

Hi Friends,

What is the error in this code?

DELETE DDTAB WHERE PICK = 'X'.

(DDTAB is the database table).

I am getting an error.

Kindly let me know what is wrong with this code.

Regards,

Mark K

[Former Member]

You can use:

delete FROM dbtab where...

I hope to help you!

[Former Member]

u need to mention all the primary keys in the where condition.

Ramesh.

[Former Member]

DELETE from DDTAB WHERE PICK = 'X'.

regards

shiba

[alex_m]

Use statement

DELETE from DDTAB WHERE PICK = 'X'.

[Former Member]

hi Mark,

It should be

DELETE  FROM DDTAB WHERE PICK = 'X'.

... Even include all the key fields in the statement in order to avoid redundancy while deleting the records from database ..

Regards,

Santosh

[Former Member]

Hi,

Use

DELETE from DDTAB WHERE PICK = 'X'.

Regards,

GSR.

[Former Member]

PARAMETERS p_carrid TYPE sflight-carrid. 

DELETE FROM sflight 
WHERE  carrid = p_carrid AND 
       fldate = sy-datum AND 
       seatsocc = 0.

[Former Member]

Mark ,

Use below syntax.

DELETE TABLE <itab> WITH TABLE KEY <k1> = <f 1> ... <k n> = <f n>.

Pls. mark if useful.