topic Re: difference update and insert in Application Development and Automation Discussions

difference update and insert

Former Member — Wed, 19 Dec 2007 06:57:57 GMT

what is the difference between update and insert in the case of database tables? what does update do and what does insert do?

Re: difference update and insert

Former Member — Wed, 19 Dec 2007 07:00:49 GMT

INSERT is to add a new record to database.

UPDATE is to modify a field value of an existing record in database.

Re: difference update and insert

Former Member — Wed, 19 Dec 2007 07:01:03 GMT

HI ,

in the name itself meaning is there

1. Insert is for inserting new row into Database table .

2. Update is for changing the existing row in Database Table.

THX

Re: difference update and insert

Former Member — Wed, 19 Dec 2007 07:03:28 GMT

Insert is to insert a new row into the database table

whers as update is to change the exsting row in the database table

plzz reward if usefull

feel free to ask any quiries my mail id is mutyalasunilkumar@gmail.com

Re: difference update and insert

Former Member — Wed, 19 Dec 2007 07:03:46 GMT

hi,

insert ... will only insert a new record ...

http://www.sts.tu-harburg.de/teaching/sap_r3/ABAP4/insert_d.htm

update : will only update the existing record...

http://www.sts.tu-harburg.de/teaching/sap_r3/ABAP4/update.htm

Hope this is helpful, Do reward.

Re: difference update and insert

Nimesh_S_Patel — Wed, 19 Dec 2007 07:04:40 GMT

Hi,

Insert Functionality,

Inserts new lines in a database table.By default, data is only inserted in the current client. Data can only be inserted using a view if the view refers to a single table and was defined in the ABAP Dictionary with the maintenance status "No restriction".

Update Functionality,

Updates values in a database table. Normally, lines are updated only in the current client.

INSERT & UPDATE belongs to the Open SQL command set.

Thanks

Nimesh S. Patel

Re: difference update and insert

abdul_hakim — Wed, 19 Dec 2007 08:46:33 GMT

Hi,

INSERT- to insert the data record.

UPDATE - to update the existing data record

Cheers,

Hakim