2007 Apr 18 7:10 AM
Hi All,
I am modifying a table maintenace of a Z table. My requirment is to add a new entry in to table as user changes some field's values for already existing records in table.
I have added my piece of code in a module in PAI of the table maintenance screen,
where i am modifying the DB table but the problem is after pressing save the new entry is not shown on the screen and when i go back and again comes to table maintenance screen the table is updated in way i want it to be..
Is this because i am modifying the DB table in the table's maintenace view ??
Is their any possible event available in table maintence or any other way which i can use??
Thanks in advace for your ansers,
Regards,
Manu Parihar.
2007 Apr 18 7:43 AM
Hello,
If it is the new entry u r trying to create u can use
event 05
iF it is changing the existing ectry then u have to use
EVENT 01 . in table maintenence generator .
In the corresponding PAI use Total structure to ge the reflections in TMG
regards
2007 Apr 18 7:14 AM
Use COMMIT statement after DB update.
that will solve the problem.
2007 Apr 18 7:44 AM
Hi,
Thanks for your answer;
But i've cheked this even using commit is not helping. The record i am changing is not apperaing on screen whereas the newly created record is coming. and both the records comes when i go back and comes again to maintenace screen.
2007 Apr 18 7:43 AM
Hello,
If it is the new entry u r trying to create u can use
event 05
iF it is changing the existing ectry then u have to use
EVENT 01 . in table maintenence generator .
In the corresponding PAI use Total structure to ge the reflections in TMG
regards
2007 Apr 18 7:48 AM
Hi,
I am changing already existing entry and i tried using EVENT 01 (Before saving)
but it doesn't work out .
I tried using Total structure as well, then my cahnges aswell the new enrty was displaying on the screen but then DB was not updating and when i again checked the table entries my cahnges were not saved.
A small qestion is this structure Total finally updates the table control in TMG
Regards,
Manu
2007 Jul 11 11:25 AM
Hi ,
Yes the structure TOTAL will update the data and displays the same on TMG
regards,