An error "Record changed by another user" in MIDAS applicatin.

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Vytas

An error "Record changed by another user" in MIDAS applicatin.

Post by Vytas » Mon 14 Feb 2005 13:14

I am working with MIDAS Application. On server side I used TMSQuery components, TdatasetProvider property ResolveToDatase is assigned to TRUE. The problem is: in client application I inserted record and applied changes to database. After that I tried to refresh record with TClientDataset method RefreshRecord. Server always reports an error "Record changed by another user". Is solution of this problem?

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Tue 15 Feb 2005 07:19

Usually it is a result of incorrect chosen key fields. Try to set DataSetProvider.UpdateMode := upWhereKeyOnly

Post Reply