topic how to update a DB table using the table control in Application Development and Automation Discussions

how to update a DB table using the table control

Former Member — Tue, 20 Mar 2007 14:19:16 GMT

HI Experts,

I have built a table control based on a DB table using table control wizard.I have added the code to insert a blank line to the table control. I have added another button to update the data into the DB table. Now I want ot enter the values in the blank line and click on the update button the values should get updated in the DB table. what is the logic i need to write to achieve this??

thanks in advance

sankar

Re: how to update a DB table using the table control

Former Member — Tue, 20 Mar 2007 14:21:36 GMT

HI Sankar,

Refer these programs

RSDEMO_TABLE_CONTROL

DEMO_DYNPRO_TABLE_CONTROL_1

DEMO_DYNPRO_TABLE_CONTROL_2

RSDEMO02

Regards,

Santosh

Re: how to update a DB table using the table control

amit_khare — Tue, 20 Mar 2007 14:21:42 GMT

Check these reports in SE38.

DEMO_DYNPRO_TABLE_CONTROL_1

DEMO_DYNPRO_TABLE_CONTROL_2

DEMO_DYNPRO_TABCONT_LOOP_AT.

Regards,

Amit

Re: how to update a DB table using the table control

Former Member — Tue, 20 Mar 2007 14:29:47 GMT

hi guys,

thnaks for your reply

Unfortunately none of the program is helpful. No program talks about the updation of the data from the table control to the DB table..

thanks

sankar

Re: how to update a DB table using the table control

Former Member — Tue, 20 Mar 2007 15:23:42 GMT

Whenever you create a tablecontrol , u assign some internal table or database table to it. In case of internal table , if u want to update database , u just have to write an update DB from internal table in PAI of your program.I hope its helpful for you .

Reagards

Madhumati

*Rewards points if helpful

Re: how to update a DB table using the table control

Former Member — Tue, 20 Mar 2007 18:22:17 GMT

Hi,

For eg: itab is the table control.

In PAI:

if sy-ucomm = 'UPDATE':

update mara from itab.

ENDIF.

Br,

Laxmi

Re: how to update a DB table using the table control

Former Member — Fri, 25 May 2007 07:25:29 GMT

Hi Madhumati,

I also have to do same sineario in my program , if you have solved this problem please send me my persional id itsajaypandey@yahoo.co.in .

I am waiting for your reply .:)

Thankx in Advance

Ajay Pandey