topic Re: Deleting string data is not working in Application Development and Automation Discussions

Deleting string data is not working

Former Member — Tue, 19 May 2009 12:03:46 GMT

I have created one temporary table and added data manuely

there is so many rows contains tmststats as 'Approved'

After executing these statement also it is not deleting.

DELETE i_output WHERE tmststats EQ u2018Approvedu2019.

the declaration of tmststats is like

tmststats(30) type c

Regards

Sebastian

Re: Deleting string data is not working

rainer_hbenthal — Tue, 19 May 2009 12:05:11 GMT

whats the value of sy-subrc and sy-dbcnt after the delete?

Re: Deleting string data is not working

former_member229729 — Tue, 19 May 2009 12:06:37 GMT

Hi,

It is not clear that, whether you want to delete record from Standard Table or Internal table.

Please clarify.

Rgds.,

RamaniN

Re: Deleting string data is not working

Former Member — Tue, 19 May 2009 12:07:15 GMT

Hi John,

ur checking with table field,

please give EQ 'APPROVED' insted of 'Approved'.

Re: Deleting string data is not working

Former Member — Tue, 19 May 2009 12:08:18 GMT

HI,

The syntax seems to be correct. check with 'APPROVED' ...it may work. Check for sy-subrc after the delete statement .

Re: Deleting string data is not working

vallamuthu_madheswaran2 — Tue, 19 May 2009 12:11:00 GMT

Hi,

DATA: L_DATA(20) TYPE C VALUE 'Approved'.

condense l_data.

DELETE i_output WHERE tmststats EQ l_data.

Thanks & Regards,

Vallamuthu.M

Re: Deleting string data is not working

former_member222860 — Tue, 19 May 2009 12:15:31 GMT

Hi,

DELETE i_output WHERE tmststats EQ u2018APPROVEDu2019.   "Check with all Caps

Re: Deleting string data is not working

Former Member — Tue, 19 May 2009 12:29:08 GMT

I am using Internal table, I have stored data as 'Approved' not capital

if checking with upper case also it is not working

Regards

Sebastian John

Re: Deleting string data is not working

Former Member — Tue, 19 May 2009 12:32:15 GMT

Thanks for everybody, its woking fine.

it is my mistake, inside the data having some mismatching.

Regards

Sebastian John

Re: Deleting string data is not working

Former Member — Tue, 19 May 2009 12:45:22 GMT

Hi,

Check with.

DELETE i_output WHERE tmststats EQ u2018APPROVEDu2019.

if sy-subrc = 0.

endif.

Hrere u check wgt is the vale of sy-subrc whether it is 0 or 4, if it is 0 then it will delete.

Regards