---

scenario

We have a to update a row of the EmployeeTable. This table is look like below.

EmpId	EmpName	DeptId
E001	Rumman Ansari	D001
E002	Osman Ali Sk	D001

Task 1: You have to update a row inside the table.

Task 2: You have to update all the rows inside the table which matches the specific conditions.

Update data in a table X++ code. Single Row

This code will update only the first row

static void DataInsertionJob(Args _args)
{ 
     EmployeeMy empdet; 
        // in this case only single row will update
        ttsbegin;
            select forupdate empdet where empdet.DeptId == "D001";
            empdet.EmpName="John";
            empdet.update();
        ttscommit;
        info("Data Updated");
}

Output of the code

EmpId	EmpName	DeptId
E001	John	D001
E002	Osman Ali Sk	D001

Update data in a table X++ code. All rows

This code will update all the rows present in the data set which matches the conditions.

static void DataUpdateJob(Args _args)
{ 
     EmployeeMy empdet; 
       
// the below code update the all the rows
        update_recordset empdet setting
            EmpName="John"
            where empdet.DeptId == "D001";
            info("All Data Updated");
}

Output of the code

EmpId	EmpName	DeptId
E001	John	D001
E002	John	D001

Another Way you can also do

static void DataUpdateJob(Args _args)
{
    EmployeeMy empdet;
    while select empdet
        where empdet.DeptId == "D001"
    {
        empdet.EmpName = "John";
        empdet.update();
    }
    info("All Data Updated");
}

---