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:

SELECT {TRAVELTRANSPORTUNIT}.* FROM {TRAVELTRANSPORTUNIT}

WITH (TABLOCK, HOLDLOCK).


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.