Page 1 of 1

optmistic lock

Posted: Fri 10 Jul 2009 17:15
by eug
Dear team devart, i have a problem:

Table ART:
Type InnoDB
CheckRowversion=True
StrictUpdate = true
Cacheupdate =true

Pc A
Record X -> edit
Pc B
Record X -> edit
Record X -> modified
Record X -> post
Record X -> applyudates;

Pc A
Record X -> post
Error "Update failed found 0 Records"

How can I fix this error?
Thanks in advance
Sorry my bad English.

Posted: Wed 15 Jul 2009 10:13
by Challenger
You can use pessimistic lock in this case. For more information please refer to the reference of the TMyQuery.LockMode property in the MyDAC help.