topic Re: Update Command is not working. in Application Development and Automation Discussions

Update Command is not working.

Former Member — Thu, 30 Oct 2008 13:54:09 GMT

Hi,

There are 15 fields in the database table. The first 5 fields are set as primary keys. In the table, only the first field has got unique values. In the next 4 primary keys the values are getting repeated.

Now, i am trying to modify the 10th field using Update Command.

I have written the below command.

Updated ZOMT_PROCESS using WL_INITIAL_VALUES.

The record is not getting modified in the database table with the values of the work area WL_INITIAL_VALUES.

What could be the problem?

Re: Update Command is not working.

matt — Thu, 30 Oct 2008 16:29:36 GMT

You've forgotten to commit?

Re: Update Command is not working.

ThomasZloch — Thu, 30 Oct 2008 16:32:13 GMT

what is the value of SY-SUBRC immediately after the UPDATE? If 4 and not 0, then there is something wrong in your work area.

Thomas

Re: Update Command is not working.

former_member585060 — Thu, 30 Oct 2008 16:43:26 GMT

Hi,

Move all the modifiable work area fields to an Internal table and modify the ztable.

Use the following syntax

LOOP AT i_selected_rows INTO w_selected_rows.

READ TABLE itab INTO wa INDEX w_selected_rows-index.

IF sy-subrc EQ 0.

MOVE-CORRESPONDING wa TO w_modified.

APPEND w_modified TO i_modified.

ENDIF.

ENDLOOP.

MODIFY zzzmaterial FROM TABLE i_modified.

Regards

Bala Krishna

Re: Update Command is not working.

GeraldP — Thu, 30 Oct 2008 21:34:03 GMT

Could you please send your complete Sourcecode.

Otherwise we can only imagine your problem.

Thanks

Gerald

Re: Update Command is not working.

GeraldP — Thu, 30 Oct 2008 21:35:10 GMT

Could you please send your complete Sourcecode.

Otherwise we can only imagine your problem.

Thanks

Gerald