Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

delete record confirmation.

Former Member
0 Kudos
113

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

1 ACCEPTED SOLUTION

Former Member
0 Kudos
58

Hi,

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

Regards,

Nandha

5 REPLIES 5

Former Member
0 Kudos
59

Hi,

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

Regards,

Nandha

Former Member
0 Kudos
58

Hi,

Sy-subrc will work for delete statement.

Former Member
0 Kudos
58

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
0 Kudos
58

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
0 Kudos
58

Hi ,

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

Thanks

Shrila