topic Re: update database in Application Development and Automation Discussions

update database

Former Member — Tue, 09 Dec 2008 08:42:54 GMT

I have done an append structure in the database LIPS

and i am doing an update in the tabel LIPS

UPDATE LIPS SET ZFALG = X

WHERE using all the primary condition

THe row that i am trying to update exist in the table lips. 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.

Please advise where i can look

Re: update database

Former Member — Tue, 09 Dec 2008 08:46:44 GMT

Use COMMIT WORK after Update statemant

Re: update database

Former Member — Tue, 09 Dec 2008 08:48:17 GMT

try this:


UPDATE LIPS SET ZFALG = X
WHERE using all the primary condition
if sy-subrc = 0.
 commit work.
endif.

Re: update database

Former Member — Tue, 09 Dec 2008 08:48:45 GMT

i am using commit work. problem still there

Re: update database

tarangini_katta — Tue, 09 Dec 2008 08:49:51 GMT

Hi ,

After Update statemnt use 'COMMIT WORK'.

May be it will helpful to you.

Thanks,

Re: update database

Former Member — Tue, 09 Dec 2008 08:50:17 GMT

What happens while normal run without debug?

Re: update database

tarangini_katta — Tue, 09 Dec 2008 08:51:27 GMT

Hi,

Then do one thing.

Go to SE14 Give table as 'LIPS' and display.

Click on 'Activate and adjust database table'

Then do the update after that use comit work

Thanks

Re: update database

Former Member — Tue, 09 Dec 2008 08:56:18 GMT

I dont know what exactly you are looking for but this is not a good practise to update a standard database through a program directly as so many foreign key relations are there. instead use BDC to update the LIPS table. for more information please contact your Functional Consultant.

If you still want to modify the table check there is any CONVERSION EXITS available for the VBELN if so go to domain of the vbeln and double click it you can find the CONVERSION EXIT function modules

use them in the program then update the table

Best Regards

Ramchander Rao.K

Re: update database

Former Member — Tue, 09 Dec 2008 08:57:20 GMT

with debug update is done. without debug the update is not done sy-subrc is 0

Re: update database

Former Member — Tue, 09 Dec 2008 09:11:56 GMT

The conversion is done properly

Re: update database

Former Member — Tue, 09 Dec 2008 09:22:37 GMT

try to use modify statement when we have to change existing line we use modify else update

regards reeha

Re: update database

Former Member — Tue, 09 Dec 2008 09:41:50 GMT

modify may create a new line in database. update will modify existing line

Re: update database

Former Member — Tue, 09 Dec 2008 09:59:50 GMT

HI,

Updating standard table for a z-field is not at all a problem. And you have to use update only.

Since it is working in Debug mode could you for once try putting a wait and Commit?

 UPDATE LIPS SET ZFALG = 'X'
WHERE using all the primary condition
if sy-subrc = 0.
 wait for 5 seconds.
 commit work.
endif.

Re: update database

Former Member — Mon, 26 Jan 2009 09:02:11 GMT

hi,

i have same problem. could you tell how you solved it? Thanks..