Hi, I'm starting to learn empire-db. I have a problem with the following situation. My goal is to: 1- Select some records from the database (e.g., all employees where department = X) 2- Change some values on those records (e.g., add an amount to the salary) 3- Save those records back to the database
Step 2 is done interactively by the user, so I cannot do steps 1,2,3 in a single UPDATE statement. My question is: if I build the query using a DBCommand, how do I get its results as a list of DBRecords? I believe I need DBRecords in step 3 to run the update. I see how: - a DBReader can give me a list of beans, but not a list of DBRecords? - a DBReader can return an iterator of DBRecordData, but I'm not sure I know how to use that. - I can wrap a DBCommand using a DBQuery, but from there I can only read records of which I can provide the primary key (readRecord() method), which I can't since I don't know what the result of my query contains. Have I missed anything in the docs? Thank you for any help Regards Paolo
