topic Insert multiple records into database through Table control in Application Development and Automation Discussions

Insert multiple records into database through Table control

Former Member — Thu, 28 Jun 2012 05:32:14 GMT

Hi I have a requirement,

Update database table through table control and also delete the selected row from table control and database.

also edit the existing data in table control and add the data to existing data in table control

Please help me out hee...

Thanks,

Mohan

Moderator Message: Search in SCN and try it yourself first instead of dumping your requirement here.

Message was edited by: Kesavadas Thekkillath

former_member209920 — Thu, 28 Jun 2012 05:54:01 GMT

You can make Table Maintenance Generator for your table.

Or other way is in PAI of the screen containing table control write your code to update database tables. (deletion, insertion or modification)

Regards

Manu B

Former Member — Thu, 28 Jun 2012 05:57:46 GMT

Use table control wizard. It has all those options you mentioned about table control.

For updating the databases, you will have to just code

MODIFY dbtab FROM TABLE itab.