topic Re: Update or delete in Application Development and Automation Discussions

Update or delete

Former Member — Fri, 29 Jun 2007 12:04:09 GMT

Hi,

I want to know the basic difference between modify database table and update database table.

Thanks & Regards,

Abhishek Sarkar

Re: Update or delete

Former Member — Fri, 29 Jun 2007 12:07:18 GMT

Hi,

Modify will update the existing record if record is present.

If record is not present it will insert a new record.

Update will update the existing record if record is present.

Reward if helpful.

Re: Update or delete

Former Member — Fri, 29 Jun 2007 12:09:43 GMT

Hi Abhishek,

Modify will create a new record if the record which it needs to modify is not there in DB.

Update can nly update the records, if the record is not there then it will not do anything and sy-subrc will be 4.

Reward points if useful.

Regards,

Atish

Re: Update or delete

Former Member — Fri, 29 Jun 2007 12:09:45 GMT

Hi,

Update will update the existing recorrds else it will not work if records not present

Modify will make changes to existing recors present in DB table,

If no records then it will create a new record in DB table..

regards,

nazeer

Re: Update or delete

Former Member — Fri, 29 Jun 2007 12:10:59 GMT

Hi Abhishek,

The difference is that update only changes existing lines in the database table. Modify does the same, but also inserts lines if they don't exist in the database.

The syntax for update is:

UPDATE target source.

For modify:

MODIFY target FROM source

Greets,

Ivo

Re: Update or delete

Former Member — Fri, 29 Jun 2007 12:11:19 GMT

Update will update the existing record else it will fail if the record is nt there.

and Modify will create a new records if the record is not present with the key combnation, else it will modify the record.

Regards

Vijay

Re: Update or delete

Former Member — Fri, 29 Jun 2007 12:12:08 GMT

hi abhishek,

there is a minute difference between Modify & Update.

Modify tries to make the prescribed change for a record. If it fails to find such a record, it inserts a new record with the prescribed values.

Update instead updates the table with the change and will not try to insert a new record no matter what.

Award points if this is helpful

Kiran