topic Delete from table type. in Application Development and Automation Discussions

Delete from table type.

Former Member — Thu, 19 Oct 2006 21:56:45 GMT

Hello,

I have a need to delete some entries from a table type where ID = some string.

Is it possible to do it in code without loops?

Can you plese provide correct syntax?

Thank you.

Georgy

RichHeilman — Thu, 19 Oct 2006 21:58:44 GMT

I assume that you have an internal table describe by a table type. You can use the syntax below.

delete itab where ID = <some_value>.

Regards,

Rich Heilman

Former Member — Thu, 19 Oct 2006 22:00:10 GMT

Hi,

Use the where condition in the delete statement..

DELETE ITAB WHERE FIELDNAME = 'SOME STRING'..

Thanks,

Naren

Former Member — Thu, 19 Oct 2006 22:01:15 GMT

Hello Rich,

Thanks for the answer.

I was doing

delete from itab where ...

This is why it was not working.

10 points to you since you are the first one to reply.

Thank you.

Gerogy

RichHeilman — Thu, 19 Oct 2006 22:03:24 GMT

the DELETE FROM... syntax is when working with a database table.

Regards,

Rich Heilman

Former Member — Thu, 19 Oct 2006 22:04:17 GMT

Hi Georgy

It must be an internal table which might have been defined from table type.

Yes you can delete records from internal table. Here are few statements and use whichever suits your requirement.

- DELETE itab INDEX idx.

- DELETE itab FROM idx1 TO idx2.

- DELETE itab WHERE Field = Value.

- DELETE ADJACENT DUPLICATES FROM itab Comparing Field1 Field2 .... (Sort the table by Field1 Field2 .. before deleting duplicate entries)

Former Member — Thu, 19 Oct 2006 22:04:40 GMT

That is correct.

Thanks.