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

Set the appropiate type based on the database engine (e.g. for SQL Server, integer maps to int and datetime to datetime)

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

3. Select the concurreny type

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

This is the name of the column you added in Step1