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

Update statement not working

Former Member — Fri, 04 Apr 2008 18:07:31 GMT

I have the following in some code and the update statement isn't working:

    SELECT SINGLE * FROM zprodorder.
    zprodorder-aufnr = wa_afko-aufnr.
    UPDATE zprodorder.

Regards,

Davis

Re: Update statement not working

former_member194669 — Fri, 04 Apr 2008 18:10:10 GMT

Whether COMMIT WORK is available after UPDATE zprodorder.?


SELECT SINGLE * FROM zprodorder.
    zprodorder-aufnr = wa_afko-aufnr.
    UPDATE zprodorder.
    Commit work.

a®

Re: Update statement not working

Former Member — Fri, 04 Apr 2008 18:17:37 GMT

hi ,

check this simple example..to under stand the update command

PARAMETERS: p_carrid TYPE sflight-carrid,

percent TYPE p LENGTH 1 DECIMALS 0.

DATA sflight_tab TYPE TABLE OF sflight.

FIELD-SYMBOLS <sflight> TYPE sflight.

SELECT *

FROM sflight

INTO TABLE sflight_tab

WHERE carrid = p_carrid AND

fldate = sy-datum.

IF sy-subrc = 0.

LOOP AT sflight_tab ASSIGNING <sflight>.

<sflight>-price =

<sflight>-price * ( 1 - percent / 100 ).

ENDLOOP.

ENDIF.

UPDATE sflight FROM TABLE sflight_tab.

regards,

venkat.

Re: Update statement not working

Former Member — Fri, 04 Apr 2008 18:17:49 GMT

I didn't think it was needed because I have an update statement directly above it (on a z-field on AFKO) and it works every time. Could the issue be that my table is starting off as initial? The table holds one field, aufnr and it is currently initial. We are using this table to hold one single record. It is being used to have a starting point for an idoc routine.

I just tried a commit work and it doesn't seem to help. I guess I'll try a using a work area next.

Edited by: Davis on Apr 4, 2008 2:22 PM

Re: Update statement not working

former_member194669 — Fri, 04 Apr 2008 18:24:46 GMT

May be a chance of table be startoff with initial.,

make the code as this way


SELECT SINGLE * FROM zprodorder.
if sy-subrc eq 0.
    zprodorder-aufnr = wa_afko-aufnr.
    UPDATE zprodorder.
else.
    zprodorder-aufnr = wa_afko-aufnr.
    INSERT zprodorder.
endif

a®

Re: Update statement not working

Former Member — Fri, 04 Apr 2008 18:32:57 GMT

Thanks but that code doesn't work. The reason is because it comes back with sy-subrc = 0 because there is a record in the table but zprodorder-aufnr is initial.

Regards,

Davis

I may just end up doing a delete then an insert.

Edited by: Davis on Apr 4, 2008 2:33 PM

Re: Update statement not working

Former Member — Fri, 04 Apr 2008 20:34:25 GMT

I ended up doing a delete then an insert. I assume I couldn't modify because the field zprodorder-aufnr was in the initial state.