Updated: September 15, 2020 9:34am

Row Version

In Web-based applications like Prism, the Row Version field is used to track creation and updates to data records and prevent multiple users from making a simultaneous update.
For example, if User 1 is creating a document and somewhere else, User 2 is also creating a document. When User 1 and User 2 both try to post, which document will be posted?
The first time User 1 updates a data record, the row version = 1
If User 1 updates the data record again, the second time the row version = 2
Next, let's suppose User 1 and User 2 are separately changing the same record. User 1 has row version=2. User 2 also has row version=2. When User 1 updates, the row version = 3. When User 2 updates, the row version = 4.
If you don't have the latest Row Version, you cannot update the record or data. You should always get the latest Row Version if you will be updating data records.