Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

No database update after insert / update

Go to solution
Former Member

‎2006 Jul 05 2:47 PM

0 Likes
1,056

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

1 ACCEPTED SOLUTION
Read only

Go to solution
Former Member

‎2006 Jul 05 2:49 PM

0 Likes
1,017

yes do use 'commit work and wait'.

it works

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

Reply
6 REPLIES 6
Read only

Go to solution
Former Member

‎2006 Jul 05 2:49 PM

0 Likes
1,018

yes do use 'commit work and wait'.

it works

Read only

Go to solution
Former Member

‎2006 Jul 05 2:50 PM

0 Likes
1,017

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

Read only

Go to solution
Former Member

‎2006 Jul 05 2:50 PM

0 Likes
1,017

use commit work.

Read only

Go to solution
andreas_mann3
Active Contributor

‎2006 Jul 05 2:52 PM

0 Likes
1,017

hi,

you say :

...

Directly after saving - I can view them.

...

how? with se16 or program?

-> try to work with offset

A.

Read only

Go to solution
Former Member

‎2006 Jul 05 5:06 PM

0 Likes
1,017

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

Read only

Go to solution
Former Member

‎2006 Jul 05 5:09 PM

0 Likes
1,017

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.