TTable update error - record has been changed by another user
Posted on 2001-08-23
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.