topic diff between update and modify in Application Development and Automation Discussions

diff between update and modify

Former Member — Tue, 30 May 2006 06:04:05 GMT

hi everyone,

plz help me in findind the difference between update and modify statements in open sql.

thakns

aafaq husain.

Re: diff between update and modify

Former Member — Tue, 30 May 2006 06:05:57 GMT

go through this link...

Re: diff between update and modify

Former Member — Tue, 30 May 2006 06:09:17 GMT

MODIFY - Will update the table, if the data already exists, if NOT inserts new rows.

UPDATE - Will update the table, errors out if the data is not found.

In case of MODIFY the sy-subrc is always 0 so you would't know whether the data is actually updated or not.

Regards,

Ravi

Note : Please mark the helpful answers

Re: diff between update and modify

Former Member — Tue, 30 May 2006 06:09:43 GMT

hi,

modify means if record is not present it'll creat a new one.if record is present it'll modify it...

but update if record is present then only it modifies..

Re: diff between update and modify

Former Member — Tue, 30 May 2006 06:10:22 GMT

Hi Husain!

Upadte: If the key record is existing in the DBtable the key record will update success fully then sy-subrc will eq 0 or else update fails and sy-subrc will non-zero.

Modify: if the key record is existing in the DBtable then the the record will update/modify else if the key record is not existing then it will insert the new record

in dbtable.

simply to say:

modify play two roles upadate and insert depends on record existing or not.

cheers

ganesh

Re: diff between update and modify

Former Member — Tue, 30 May 2006 06:18:56 GMT

HI Hussain,

'Insert' will add a new record or a new row into the database table.

'Update' will modify a record in the DB table.

'Modify' it is a combination of both insert and update...

Also check these links

Regards,

Susmitha

Re: diff between update and modify

Former Member — Thu, 12 Apr 2007 12:25:56 GMT

thanks