Skip to Content
0
Former Member
Nov 27, 2006 at 08:39 AM

Modify the value of a column in a table

557 Views

Hi ,

I want to programatically modify the value of a certain field in the data base table from a program.

Is there some way by which i can only modify that field.

Let me illustrate my condition , assume i have a table which has

-


Material Number |Material Type | Status |

-


i want to set the status of all material of type 'ABC' to 'X' .

the logic i am following is select all data (all 3 fields) from table into an internal table where material type is 'ABC' , then modify the status field of the records and set it to 'X' and then update the table from this internal table.

Is there some way by which i can modify the table directly without accessing all the records from it.

Thanks

Arun