Can AnyBody tell me that From where does System Fetch the Id Assigned to RecVersion Field on the updation of record in the table i.e The default Value of recversion is 1 when the record is created but when i update the Record,it assigns a random Id like **“167843”.**Is it Randomly Generated or the system fetches it??
It’s a random value.
It’s used to detect concurrent updates and if it was taken from a number sequence, there would be either a risk of getting the same value (which would render the conflict detection useless), or there would have to be a locking mechanism, which would go against the purpose of optimistic concurrency control.
Thank You so much For your Reply.But I really want to know does system maintain any log for Recversion including Table ids & Record Ids.
No. There is no reason for any logging.