topic Re: regarding update and modify in Application Development and Automation Discussions

regarding update and modify

Former Member — Thu, 02 Aug 2007 13:48:46 GMT

good evening.

what is the difference between update keyword and modify keyword.

thanks and regards,

k.swaminath reddy.

Re: regarding update and modify

Former Member — Thu, 02 Aug 2007 13:51:29 GMT

basicly

UPDATE - updates existing table rows

MODIFY - updates existing rows but also APPENDS new one's which you want to append if they don't exist already,if they exist - this command changes them.

Regards

Yossi

Re: regarding update and modify

Former Member — Thu, 02 Aug 2007 13:52:14 GMT

Hi swaminath,

1. UPDATE = it will only update the record in database table.

if the record is NOT FOUND, based upon the primary key,

then it will give error.

2. MODIFY = If record is found (based upon the primary key)

It will update/modify the record,

OTHERWISE

It will automatically insert a new record.

regards,

amit m.

Re: regarding update and modify

Former Member — Thu, 02 Aug 2007 13:55:10 GMT

Hi,

Update you can change database primary key value which is not

possible with modify.

modify updates database when record exist else inserts new record

and also used in internal table operations.

update modified database table only when entry exist.

while using update clause use where condition else it updates all records

of table.

regards

ravish

<b>plz dont forget to reward points if useful</b>