Hi, I have a problem with my development in Outsystems 11, about the concurrence.

How can I block one or several tables to avoid concurrency?

I am using an advanced SQL, This is the syntax:



Can you help me with examples?

Thank you.

Hi Alhy,

For starters, you would want to lock as little as possible, as it will block users, and generate time-outs when the lock takes too long.

That said, the only locking action that the OutSystems Platform provides is the GetXxxForUpdate Entity Actions. So you can lock a single record. If that's not enough, you need a special semaphore Entity, so you can lock a specific record representing a specific Entity. This however relies on coding practices, and will not protect against "rogue" modifications.