<div>
?maybe<br />
<br />
try to change the updatemode-property of the ttable &nbsp;to upwherekeyonly
</div>


?maybe

try to change the updatemode-property of the ttable  to upwherekeyonly

<div>
I had tried setting UpdateMode to upWhereChanged earlier, that didn't work. &nbsp;I just tried your solution, and that didn't do anything either.
</div>


I had tried setting UpdateMode to upWhereChanged earlier, that didn't work.  I just tried your solution, and that didn't do anything either.

<div>
Do you have a before update trigger? Just a shot in the dark here...
</div>


Do you have a before update trigger? Just a shot in the dark here...

<div>
Setting CachedUpdates to True and UpdateMode to upWhereKeyOnly did the trick.<br />
<br />
Thank you.<br />
<br />
Paul
</div>


Setting CachedUpdates to True and UpdateMode to upWhereKeyOnly did the trick.

Thank you.

Paul

<div>
well, glad you got it work,<br />
thanks for the points :-)<br />
<br />
good luck again<br />
<br />
meikl ;-)
</div>


well, glad you got it work,
thanks for the points :-)

good luck again

meikl ;-)

<div>
<div class="content wysiwyg-content">
I am working with Delphi 5 Enterprise, and accessing a MSSQL 7.0 database through the native MSSQL BDE driver. &nbsp;On a table that I am trying to update opened with a TTable object, when I call Edit, I get the error message &quot;Couldn't perform update because the record has been changed by another user&quot;. &nbsp;Append works just fine.<br />
<br />
On Borland's site, I found two references to this, one relating to Sybase and CTLIB with small datetimes, and the other on using SET NOCOUNT ON. &nbsp;Neither of these applies to my situation.<br />
<br />
Other tables are updating just fine, and I don't see anything obviously wrong.<br />
<br />
Any help would be greatly appreciated. &nbsp;Thank you.
</div>
</div>


I am working with Delphi 5 Enterprise, and accessing a MSSQL 7.0 database through the native MSSQL BDE driver.  On a table that I am trying to update opened with a TTable object, when I call Edit, I get the error message "Couldn't perform update because the record has been changed by another user".  Append works just fine.

On Borland's site, I found two references to this, one relating to Sybase and CTLIB with small datetimes, and the other on using SET NOCOUNT ON.  Neither of these applies to my situation.

Other tables are updating just fine, and I don't see anything obviously wrong.

Any help would be greatly appreciated.  Thank you.

TTable update error - record has been changed by another user

Delphi is the most powerful Object Pascal IDE and component library for cross-platform Native App Development with flexible Cloud services and broad IoT connectivity. It provides powerful VCL controls for Windows 10 and enables FMX development for Windows, Mac and Mobile. Delphi is your choice for ultrafast Enterprise Strong Development™. Look for increased memory for large projects, extended multi-monitor support, improved Object Inspector and much more. Delphi is 5x faster for development and deployment across multiple desktop, mobile, cloud and database platforms including 32-bit and 64-bit Windows 10.