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

Update/Modify not working

former_member5472 — Wed, 05 Mar 2008 13:08:34 GMT

hi,

i have ztable

mandt key field

ztest1 key field

ztest2 key field

ztest2 non key field

when i'm trying to modify any key field, MODIFY keyword is actually adding a new record in the Database. it is because the new combination of key fields is unique.

i tried using update statement . Update is not working as the combination key is creating a new record which is not present in Db and hence , its not updating.

do we have any workaround on this ??

if i update the key field same field should be updated with other fields intact

please help.

Re: Update/Modify not working

Former Member — Wed, 05 Mar 2008 13:10:58 GMT

Hi Pratyush,

In this case UPDATE key word works. You must be passing wrong parameters.

Just check your code once again.

Regards,

Atish

Re: Update/Modify not working

Former Member — Wed, 05 Mar 2008 13:20:41 GMT

key field means unique record.

if u try to change a key field it will add a new entry.

to an existing entry with a key combination u can change only the non-key fields.

else u need to delete the record combination and add the new combination.

Re: Update/Modify not working

former_member5472 — Wed, 05 Mar 2008 14:18:06 GMT

hi,

correct me if i'm wrong.

Update keyword works for existing records in the DB table? if after changing the record , the comdination of key fields are already present in the DB, then it will update or else it won't update.(sy-subrc = 4).

Re: Update/Modify not working

Former Member — Wed, 05 Mar 2008 14:58:40 GMT

Yes. Your understanding is correct.

Regards,

Atish

Re: Update/Modify not working

former_member5472 — Thu, 06 Mar 2008 05:02:03 GMT

hi,

thanks for all your replies.