updating database table

[Former Member]

hi,

I have done an append structure in the database EBAN

and i am doing an update in the table EBAN

UPDATE EBAN SET ZFLAG = 'X'

WHERE using all the primary condition

The row that i am trying to update exist in the table Eban. The problem that i am having is that sometimes the update is done sometimes not.

I check in debug for the data that is done updating properly and in debug the update is done. But not when executing the program without debug. I've tried COMMIT statement after UPDATE but it didn't work. how can i solve this?

[Former Member]

Hi Deniz,

try like this...

SELECT *

FROM EBAN

INTO WA_EBAN

WHERE <primary conditions which you are giving in UPDATE>.

if sy-subrc eq 0.

wa_eban-zfalg = 'X'.

update eban from wa_eban.

endif.

it should work.

-- Jyothi

[Former Member]

hi Jyothi,

thanks for the quick answer. i've tried your suggestion but it didn't work.

[Former Member]

Hi

My intention there is whether the record is existing in the system or not. What is the sy-subrc value. Did you check?

if that is zero then it must work.

Ensure that it is zero and then remove the select. It is just for checking.

- Jyothi

[rainer_hbenthal]

>

> the select. It is just for checking.

its more then superfluous

[rainer_hbenthal]

check sy-subrc after your update. its not necessary to do a select before update as suggested before.

[Former Member]

after commit. jus try using the WAIT statement and check.

[Former Member]

if you added field in standard strcture in EABN , for this you can find any exit you have to appned the strcture in exit level that will update the standard table automatically...

[Former Member]

Hi,

Lock the record before you update and unlock it after the update is done.

Use the lock object EMEBANE

CALL FUNCTION 'ENQUEUE_EMEBANE'  " for locking, pass the necessary parameters

IF sy-subrc <> 0.
 MESSAGE ID SY-MSGID TYPE 'E' NUMBER SY-MSGNO
         WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.

UPDATE EBAN SET ZFLAG = 'X'
WHERE using all the primary condition.

if sy-subrc = 0.
 " Update successfull !
else.
 " Update unsuccessfull !
endif.

call function DEQUEUE_EMEBANE      " For unlocking. Pass the necessary parameters 

IF sy-subrc <> 0.
 MESSAGE ID SY-MSGID TYPE 'E' NUMBER SY-MSGNO
         WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.

regards,

Advait

[Former Member]

hi Advait,

i've tried your suggestion but it didn't work. like before when i check in debug mode the field is updated but when i execute the program without debug it doesn't work (i got error message: "Object requested is currently locked by user "). i want to know the differance between running program with debug mode and without debug mode.

[Former Member]

Ideally it should work.

Have you written this code in a user exit or it is a stand alone program ?

regards,

Advait

Edited by: Advait Gode on Jan 22, 2009 4:15 PM

[Former Member]

I've written code in a function module i wrote.