Hi,
any known issues about this?
I've encountered a custom method which tries to update a set of record by joining 2 tables with the update_recordset statement. Something like:
update_recordset myTable1
setting [fieldsList]
join myTable2
where [conditions]
The instruction returns this error "could not update a record" and i can see this join doesn't retrieves anything.
If i do the same with a "while select forUpdate" statement, it works fine. The records are retrieved and updated.
Obviously this takes much more time than the update_recordset.
Any idea about this issue?
Thank you in advance