topic Delete all table entries problem in Application Development and Automation Discussions

Delete all table entries problem

Former Member — Wed, 21 Oct 2009 09:01:10 GMT

HI,

i use the commend delete from Zemp_table in order to delete all entries for the table

and in the code inspector i get this warning :

Large table Zemp_table: No WHERE condition

How can I do that without the warning since i need to delete all table entries .

Regards

Joy

Re: Delete all table entries problem

rainer_hbenthal — Wed, 21 Oct 2009 09:05:09 GMT

Its just a warning....

Re: Delete all table entries problem

Former Member — Wed, 21 Oct 2009 09:07:30 GMT

HI,

you can select the entire data from the ztable into an internal table

then delete ztable from table itab.

Regards,

Venkatesh

Re: Delete all table entries problem

Former Member — Wed, 21 Oct 2009 09:41:05 GMT

HI ,

i see that this is only a warning but there is no way to overcome it ?

Regards

Joy

Edited by: Joy Stpr on Oct 21, 2009 12:06 PM

Re: Delete all table entries problem

Former Member — Wed, 21 Oct 2009 10:14:14 GMT

just try delete Zemp_table , instead of delete from Zemp_table in order to delete all entries for the table .

Re: Delete all table entries problem

ThomasZloch — Wed, 21 Oct 2009 10:38:01 GMT

If you must, you can suppress the warning with an appropriate "#EC comment, or add a WHERE-condition that covers all records (e.g. "keyfield" is not initial).

Thomas