How to read and write within the same transaction?

I used this construct according to the documentation, and it works fine.

My question is, how do I read a value in the record from the table within the same transaction? In this case I need the existing value to do a calculation on that value before writing the new value to the table.

Hi Hans,

In the logic you shared, you’re loading one record from the MyTable table. Do you need access to a specific property/column from that object?

Regards,
Mark

Hi Mark,

Yes. I need access to the existing value in “Counter” so I can add 1 to it.

Hi Hans,

I checked with the product team and this feature is not available yet. We’re making changes that will allow property update for an object retrieved in the same transaction.

Regards,
Mark

Thank you!