# Concurrency

When multiple users are collaborating on the same Qommentary Writeback extension, there might be a risk of overriding someone else's data. To prevent these issues, Qommentary provides a versioning control at a record level.

To enable concurrency

1\. Add an extra column with the type **integer** or **datetime** in the destination table

{% hint style="info" %}
Set the appropiate type based on the database engine \
(e.g. for *SQL Server*, integer maps to **int** and datetime to **datetime**)
{% endhint %}

2\. Select the writeback extension and expand the Data Connections section

<div align="left"><img src="https://1677646431-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZD-BzJmQDUcNcbFznd%2F-MZD15klC4BNjg_ZK72x%2Fimage.png?alt=media&#x26;token=4f101dce-c1a8-419b-9c52-2bf56e8d074b" alt=""></div>

3\. Select the concurreny type&#x20;

<div align="left"><img src="https://1677646431-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZD-BzJmQDUcNcbFznd%2F-MZD1VB_QwsONKtJ80d9%2Fimage.png?alt=media&#x26;token=71a28501-ed7c-4561-95c7-fe6b5e55214c" alt=""></div>

| Concurreny Type | Description                                                                            |
| --------------- | -------------------------------------------------------------------------------------- |
| Integer         | Qommentary will increment the value of the integer in 1 every time a record is updated |
| DateTime        | Qommentary will generate a timestamp every time a record is updated                    |

4\. Enter the name of the concurrency colum

<div align="left"><img src="https://1677646431-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M43RhGzV8Plu0tfknia%2F-MZD3qMZ8sz20rVAp97U%2F-MZD69hWt0bWtQbcFSQu%2Fimage.png?alt=media&#x26;token=bd172615-d394-4113-b40a-f557e0a9f8e8" alt=""></div>

{% hint style="info" %}
This is the name of the column you added in Step1
{% endhint %}
