topic Re: append vs insert in Application Development and Automation Discussions

append vs insert

Former Member — Wed, 12 Sep 2007 12:48:19 GMT

what is difference while inserting row through append statement and the one inserting using insert statement.

Former Member — Wed, 12 Sep 2007 12:50:24 GMT

hi pankaj

u can insert any where in the row

but u can append only at last

Former Member — Wed, 12 Sep 2007 12:52:04 GMT

Once you use APPEND it vl add that record only at the end of the DB table.

If you use INSERT it vl add records where ever u need

For eg: INSERT Itab index 4.

Former Member — Wed, 12 Sep 2007 12:52:15 GMT

u can insert a new record in internal table at specific index using insert statement.

through append new record is added at the last position in the internal table.

reward points please...

Former Member — Wed, 12 Sep 2007 12:52:35 GMT

HI pankaj

Append is used to store the row of data the end of internal table

But insert is used to inesrt it anywhere in the rows of internal table contents.

Former Member — Wed, 12 Sep 2007 12:52:49 GMT

Hi!

You can append a line only at the end of your table.

Insert command inserts the line anywhere in the internal table.

APPEND has better performance, so mostly this command has to be used...

Regards

Tamá