topic Re: updating database table in Application Development and Automation Discussions

updating database table

Former Member — Thu, 22 Jan 2009 12:52:23 GMT

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?

Re: updating database table

Former Member — Thu, 22 Jan 2009 12:58:28 GMT

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

Re: updating database table

Former Member — Thu, 22 Jan 2009 13:29:31 GMT

hi Jyothi,

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

Re: updating database table

rainer_hbenthal — Thu, 22 Jan 2009 13:31:21 GMT

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

Re: updating database table

Former Member — Thu, 22 Jan 2009 13:39:27 GMT

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

Re: updating database table

Former Member — Thu, 22 Jan 2009 13:40:37 GMT

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

Re: updating database table

Former Member — Thu, 22 Jan 2009 13:44:48 GMT

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...

Re: updating database table

rainer_hbenthal — Thu, 22 Jan 2009 13:45:58 GMT


> the select. It is just for checking.

its more then superfluous

Re: updating database table

Former Member — Thu, 22 Jan 2009 13:50:03 GMT

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

Re: updating database table

Former Member — Thu, 22 Jan 2009 15:08:22 GMT

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.

Re: updating database table

Former Member — Thu, 22 Jan 2009 15:15:03 GMT

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

Re: updating database table

Former Member — Thu, 22 Jan 2009 15:22:15 GMT

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