updating database tables with changed field values

[Former Member]

Hi,

I am working on a module pool program.In the o/p screen there are many records.Besides each record there is a checkbox.If the user wants to change the field values of one particular record he clicks on the checkbox besides that and click on the change button.Then the control goes to update screen.In the update screen he can change the values of those fields,which he wants to change.

If the user wants to change field values for 2 or more records,then he clicks on all those checkboxes which he wants to change.Then how can he change the field values for all those records which he checked?

Is there any way to change the field values for all the checked records?

[Former Member]

Hi,

I am working on a module pool program.In the o/p screen there are many records.Besides each record there is a checkbox.If the user wants to change the field values of one particular record he clicks on the checkbox besides that and click on the change button.Then the control goes to update screen.In the update screen he can change the values of those fields,which he wants to change.

If the user wants to change field values for 2 or more records,then he clicks on all those checkboxes which he wants to change.Then how can he change the field values for all those records which he checked?

Is there any way to change the field values for all the checked records?

[Former Member]

Hi,

Use a table control in ur update screen.........

create an internal table with all the fields u hav to change

create a table control using wizard....it ll ask for an internal table......... give this int table.............

so in update screen the table control ll have the values as in int table.........change it and when u press enter/ any user action PBO is triggered and the values of that int table is updated....u can use it to update the database table if u want..............

Cheers,

jose.

[Former Member]

Hi,

Using this we can change the field values for only one checked record.I want to change the field values for all the checked records.Is this possible?If so,can you tell me how?

[Former Member]

Hi,

when u create a table control............a table ll appear in ur update screen............der u can change multiple records right...........

Cheers,

jose.

[Former Member]

Hi,

My update screen contains only the field names for which the user wants to change values.How can we change the field values for all the checked records,if we use table control?