optmistic lock

eug · Post by **eug** » Fri 10 Jul 2009 17:15

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.

Challenger · Post by **Challenger** » Wed 15 Jul 2009 10:13

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.