Delete Row og SQLServer database on table LeadSelect action

[Former Member]

Hi all,can u plz tell me how to delete the row of SQLServer database table from the webdynpro table UI element on LeadSelect action at runtime..

OnLeadSelect it shud not only delete row from webdynpro table but also from the SQL Server database table simultaneously,..

I just able to delete row from the UI Table element but not from the table of SQL database table.

If anybody knows plz share with me too...

Thanx in advance

Regards:

SK

[Former Member]

closing

[Former Member]

Plz look at the below thread

[Former Member]

Hi SK,

If you are well aware of webdynpro and RFC models , you can try this

First write a RFC in R/3 side to delete a row from the ztable with some primary key as reference import and create a model of that rfc in the webdynpro aplication you are using ,

Now you can do required binding actions between model and component controller and then to the view where the table is available , After doin these things in the onLeadSelect action call that RFC Model by passing the primary key reference available in that table ,

Hope it will work , if you have any doubt in this process let me know , i ll try to help.

Regards,

Sam Charles J.