topic Re: delete record confirmation. in Application Development and Automation Discussions

delete record confirmation.

Former Member — Thu, 05 Mar 2009 09:47:17 GMT

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 — Thu, 05 Mar 2009 09:49:22 GMT

Hi,

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

Regards,

Nandha

Former Member — Thu, 05 Mar 2009 09:52:44 GMT

Hi,

Sy-subrc will work for delete statement.

Former Member — Thu, 05 Mar 2009 09:53:46 GMT

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 — Thu, 05 Mar 2009 09:55:21 GMT

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 — Thu, 05 Mar 2009 09:56:34 GMT

Hi ,

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

Thanks

Shrila