I am trying to update/insert temp table in UI, in before.choice of before.update.db section. Its not getting it. If I dont use db.retry and commit, getting error of transaction is on. If I use db.retry and commit, getting 206 error record is not locked.
Is it we can not write update/insert in this section.

Thanks.

I think I typically use the main.table.io, but that is 4c4.

Do not use commit.transaction in before.choice and try just using "for update" in it. It might work as pressing the save button calls the commit.transaction by itself.

recently i tried without commit.transaction ... it gives transaction on error.

As mark suggested main.table.io or DAL or UE script are apt for updating other tables.

Hi,

Also, you can write your code in after.update.db.commit section if you wish to do transactions to other(temp) table on execution of any transaction on the current table.

e.g.


after.update.db.commit:
do.some.transaction()
commit.transaction()