delete record confirmation.

[Former Member]

hi,

i m giving following command

DELETE FROM crmd_orgman WHERE guid = wa_zcont_delete-guid_set.

so after record deleted from crmd_orgman i want confirmation whether really record got deleted from crmd_orgman. so what is the command ?

will just giving sy-subrc will help ?

crmd_orgman is a database table.

Pls help.

Regards,

Santosh

[Former Member]

Hi,

Check the Sy-subrc = 0 or not is enough.

Regards,

Nandha

[Former Member]

Hi,

Sy-subrc will work for delete statement.

[Former Member]

Hi,

sy-subrc = 0 is enough,if you want to re-confirm it write a select query for that particular record

if sy-subrc <> 0 then your record does not exist in that table.

Thanks & Regards,

Sateesh.

[Former Member]

Hi Santosh,

Confirmation for Delete Statement get from two fields

1. sy-subrc

2. sy-dbcnt

if sy-subrc eq 0, then the record was deleted. if sy-subrc eq 4, then the record was not found in database table.

sy-dbcnt gives the count of deleted records.

u can use of this fields for confirmation Purpose.

regards,

balakrishnan k

[Former Member]

Hi ,

Sy-subrc = 0 is enough, moreover you can giv confirmation msg after that .

Thanks

Shrila