topic Re: delete entry in Application Development and Automation Discussions

delete entry

Former Member — Fri, 15 Jun 2007 03:20:49 GMT

Hi Guys

I want to delete particular entry from ALV output and press save,it should refresh and should update the database table.

How can i proceed on this.

Thanks in advance

Re: delete entry

former_member189059 — Fri, 15 Jun 2007 03:41:12 GMT

FORM PAI_INPUT.

OK_CODE = SY-UCOMM.

CASE OK_CODE.

WHEN '&TEM'. " im not sure what the code is for the save button (u can also make your own button in a toolbar)

LOOP AT itab.

MOVE itab TO Zexttable. " zexttable is the external db table in this case

UPDATE Zexttable.

ENDLOOP.

MESSAGE S000(E4) WITH 'Data successfully saved to'

'database table'.

ENDCASE.

ENDFORM. "pai_input

Re: delete entry

Former Member — Fri, 15 Jun 2007 03:43:16 GMT

Hi,

for this delete all the database table entries first before saving the modified details.

after that use

MODIFY <DBTAB> FROM TABLE ITAB.(HERE ITAB IS UR INTERNAL TABLE WHICH CONTAINES THE DATA U R DISPLAYING IN THE ALV.)

rgds,

bharat.

Re: delete entry

Former Member — Fri, 15 Jun 2007 03:58:58 GMT

Program <b>BCALV_EDIT_04</b> This report illustrates how to add and remove lines to a table using the ALV Grid Control and how to implement the saving of the new data.

reward points it if it is usefull ..

Girish

Re: delete entry

Former Member — Fri, 15 Jun 2007 04:01:11 GMT

hi,

check the BLog:for deleting an entry:

/people/srilatha.t/blog/2007/04/13/alv-grid--delete-row-function

Capture the changes into an Internal Table based on the fields and update the Database table with that internal table using Modify/insert or Update