topic Re: Delete in Application Development and Automation Discussions

Delete

Former Member — Thu, 11 Jan 2007 10:11:59 GMT

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

Re: Delete

Former Member — Thu, 11 Jan 2007 10:13:31 GMT

You can use:

delete FROM dbtab where...

I hope to help you!

Re: Delete

Former Member — Thu, 11 Jan 2007 10:13:43 GMT

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

Ramesh.

Re: Delete

Former Member — Thu, 11 Jan 2007 10:14:06 GMT

DELETE from DDTAB WHERE PICK = 'X'.

regards

shiba

Re: Delete

alex_m — Thu, 11 Jan 2007 10:15:57 GMT

Use statement

DELETE from DDTAB WHERE PICK = 'X'.

Re: Delete

Former Member — Thu, 11 Jan 2007 10:16:39 GMT

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

Re: Delete

Former Member — Thu, 11 Jan 2007 10:16:49 GMT

Hi,

Use

DELETE from DDTAB WHERE PICK = 'X'.

Regards,

GSR.

Re: Delete

Former Member — Thu, 11 Jan 2007 10:17:05 GMT

PARAMETERS p_carrid TYPE sflight-carrid. 

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

Re: Delete

Former Member — Thu, 11 Jan 2007 10:17:59 GMT

Mark ,

Use below syntax.

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

Pls. mark if useful.