topic Re: No database update after insert / update in Application Development and Automation Discussions

No database update after insert / update

Former Member — Wed, 05 Jul 2006 13:47:37 GMT

Dear all..

I have created a small report for storing additional invoice text into a z-table. These invoice text could have the lenght of 2560 character and are needed for EDI transmission.

Directly after saving - I can view them. After some hours I am always getting empty fields wenn I try to view the data. ... for me it looks like that the table entries are buffered but nor really stored into database. Does a commit work solves this problem ?

Thanks in advance

Jürgen

Re: No database update after insert / update

Former Member — Wed, 05 Jul 2006 13:49:44 GMT

yes do use 'commit work and wait'.

it works

Re: No database update after insert / update

Former Member — Wed, 05 Jul 2006 13:50:16 GMT

Its mandatory to have the COMMIT WORK so that the data is saved to the database.

Regards,

Ravi

Note : Please mark all the helpful answers

Re: No database update after insert / update

Former Member — Wed, 05 Jul 2006 13:50:33 GMT

use commit work.

Re: No database update after insert / update

andreas_mann3 — Wed, 05 Jul 2006 13:52:01 GMT

hi,

you say :

...

Directly after saving - I can view them.

...

how? with se16 or program?

-> try to work with offset

Re: No database update after insert / update

Former Member — Wed, 05 Jul 2006 16:06:04 GMT

It may be that the actual database updates are failing. You can use transactoins SM13 and SM14 to see if there are problems with the V1 or V2 updates.

Rob

Re: No database update after insert / update

Former Member — Wed, 05 Jul 2006 16:09:20 GMT

How are storing 2560 character long texts in a Z table? Why not create a standard text and use SAVE_TEXT instead of creating a separate Z table for that.