topic Re: Update/Modify in Application Development and Automation Discussions

Update/Modify

SG141 — Fri, 17 Aug 2007 18:26:14 GMT

Based on checking certain criteria i have to change the value of a field in data base table to a new one. Which one would be a better option Update or Modify......

Re: Update/Modify

Former Member — Fri, 17 Aug 2007 18:27:35 GMT

if its one field.. then update else modify

Re: Update/Modify

Former Member — Fri, 17 Aug 2007 18:32:36 GMT

HI,

Modify is better to avoid the multiple entries.

select single * from dbtable into wa where .......

wa-field3 = 'testing'.

modify dbtable from wa.

Regards

SAB

Re: Update/Modify

Former Member — Fri, 17 Aug 2007 18:43:21 GMT

HI,

You can use modify always.. it does two things...

if record is already exist it acts as update

if record does not exist then it acts as insert.

if you are sure that the record already exist then use UPDATE..

Thanks

Mahesh

Re: Update/Modify

SG141 — Fri, 17 Aug 2007 18:49:56 GMT

Record already exits..I'll the primary key of the table and replace one of the fields in that table.

So, I'll go for Update.

Re: Update/Modify

Former Member — Fri, 17 Aug 2007 18:51:09 GMT

GOOD CHOICE

Re: Update/Modify

former_member194669 — Fri, 17 Aug 2007 18:58:28 GMT

Hi,

It it is a standard table please do not go for direct update or modify. if it is a custom table and If you want to update the primary key itself , then delete the record and then modify. before deleting please check the dependencies

aRs