What does record identification in sysdatbaselog mean

(0) Share

Report

Posted on by nithinkumar_007

152

Hi,

Could anyone please tell me what does recordidentification field in sysdatabaselog mean and for some records in the history tab in sysdatabselog form recversion is changed from 1 to some random number what does this mean.

Thanks,

Nithin.

I have the same question (0)

All responses (2)

Answers (1)

nithinkumar_007 152 on at

Like (0)

Report

RE: What does record identification in sysdatbaselog mean

Thanks a lot Nikolaos.

Was this reply helpful? Yes No
Verified answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report
RE: What does record identification in sysdatbaselog mean

Record identification shows key fields from the record that was changed. It shows TitleField1 and TitleField2 of the table.

RecVersion isa number that changes every time when a record is updated. On new records it's 1, on updated records it's not 1. RecVersion is used by the system to prevent conflicting updates.

For example:

Process 1 selects a record for update. The system looks at RecVersion, it's 12345.

Process 2 updates the same record. RecVersion is changed to 4574563.

Process 1 tries to do it's update, but if it could do it, it would overwrite any changes that Process 2 made. However it will not do the update, since it notices that RecVersion is no longer the same than it was when Process 1 started doing it's job. Instead the process fails and "Update conflict" exception is thrown.

Was this reply helpful? Yes No