MySQL: Record was changed by another user

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Lolo
Posts: 4
Joined: Tue 01 Jul 2008 15:12
Location: Germany

MySQL: Record was changed by another user

Post by Lolo » Mon 24 Nov 2008 19:34

I'm migrating a good working application from MyDAC to UniDAC. Most parts work fine but in one part of it the following problem occurs:

I very often write the same data (which was already in the record) in the same record. When I post the record, the error 'Record was changed by another user'.

This does not happen when using any version until the latest (5.70.0.41) of MyDAC, but happens with every version of UniDAC until the latest (1.20.0.13).

I'm using Turbo Delphi (BDS 2006), MySQL-Server version 5.0 until the latest version 5.0.67, it occurs on any Windows-Version of XP or Vista.

I have tested nearly all options of the TUniConnection and the TUniTable, nothing helped.

Has someone any helping ideas?

Greetings, Lolo
Top
Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Tue 25 Nov 2008 08:33

Set the LockMode property of TUniTable to lmNone for compatibility with MyDAC.
Top
Post Reply

Return to “Universal Data Access Components”