update database

[Former Member]

hi

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

[Former Member]

Use COMMIT WORK after Update statemant

[Former Member]

i am using commit work. problem still there

[Former Member]

try this:

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

[tarangini_katta]

Hi ,

After Update statemnt use 'COMMIT WORK'.

May be it will helpful to you.

Thanks,

[Former Member]

What happens while normal run without debug?

[Former Member]

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

[tarangini_katta]

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

[Former Member]

Hi

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

[Former Member]

The conversion is done properly

[Former Member]

Hi

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

regards reeha

[Former Member]

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

[Former Member]

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.

[Former Member]

hi,

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