Hi, I saw in an earlier post that you implemented concurrency in the Formspider online IDE. In the online IDE i see a new field 'Concurrency Column' available when creating a datasource based on a table. Can you explain a bit how the concurrency check is implemented and how and when to use this 'Concurrency Column' ? Thanks, Michiel |
Hi Michiel, Formspider uses optimistic locking. In other words, it allows users to edit any data but on commit it warns the user that the data he updated was changed by another person while he was editing it. This is the more common form of locking in web applications. Since database connections are shared among user sessions, it is not possible to have a database lock on a row. This also prevents user from locking rows longer than they should. We will add a concurrency tutorial explaining how to implement concurrency in a Fomspider application by tomorrow. You will see the answer of your question in this tutorial. |
Hi Michiel, We are looking forward to your feedback Regards |