topic Re: Delete statement in Application Development and Automation Discussions

Delete statement

Former Member — Thu, 09 Apr 2009 11:56:50 GMT

Hi experts,

How can I delete a record if a key field is initial.

Is it ok?

delete from t_itab

where field1 eq ' '.

I tried this one also:

delete from t_itab

where field1 is initial.

But is says: The operator IS can only be used in "f IS NULL

Re: Delete statement

Former Member — Thu, 09 Apr 2009 12:01:33 GMT

You can delete for all initial records.

Just check for the condition and say delete.

I guess you are not allowed to write initial in where clause of delete that is why it showed you that error.

Use null and ' ' instead which will work perfectly fine for your requirement.

Regards,

Lalit Mohan Gupta.

Re: Delete statement

Former Member — Thu, 09 Apr 2009 12:07:12 GMT

Try this Delete i_tab where field1 = ' '.

Re: Delete statement

Former Member — Thu, 09 Apr 2009 12:09:00 GMT

Hi,

use null, it will work...

Regards,

Pavan

Re: Delete statement

Former Member — Thu, 09 Apr 2009 13:02:41 GMT

Try this:-

Delete from t_itab where field1 is Null.

I hope, it'll work for ur requirement.

Thanks.

Anurag.

Re: Delete statement

Former Member — Thu, 09 Apr 2009 14:44:22 GMT

Hi mrwhite,

Don't use IS operator with INITIAL.

These are the following alternatives.

DELETE from t_tab where connid is null.

DELETE from t_tab where connid = space.

DELETE from t_tab where connid = ' '.

prasad GVK.

Re: Delete statement

Former Member — Fri, 10 Apr 2009 04:15:48 GMT

Hi,

I think all answers say the same thing so mine is no different

Use:

delete from t_itab where field1 is null.

But some word of precaution:

a) Dont use this statement in loop where loop is done on same internal tab t_itab.

Thanks.

Re: Delete statement

Former Member — Mon, 20 Jun 2011 09:54:53 GMT

You can delete for all initial records.

Just check for the condition and say delete.

Is it ok?

delete from t_itab

where field1 eq ' '.

I tried this one also:

delete from t_itab

where field1 is initial.

I guess you are not allowed to write initial in where clause of delete.

Regards,

Lalit Mohan Gupta.