Hi, I am using GenericDelegator to to retrieve or store data from the tables.
But I am facing some problems to update some records using delegators. e.g. I have a table as below. EMP (empId primary key, name, age, salary, dept foreign key) Here I want to update the salary of all the employees who belongs to specific department. e.g. UPDATE EMP set salary=salary * 10 where dept='QA'; So, how to put this in ofbiz delegator. How to set fields to update in query. Thanks, Vikas