Question and Answer Database FAQ: FAQ4655B — SET NOCOUNT ON causes "Couldn't perform the edit because another user changed the record" error Category: Database (MSSQL) Platform: All Windows Product: BC++5.x, C++Builder1.0, C++Builder3.x, C++Builder4.x, Delphi2.x, Delphi3.x, Delphi4.x, VdBase7.x, Question: How come after I execute SET NOCOUNT ON on MSSQL server all updates result in the error "Couldn't perform the edit because another user changed the record"? BDE error 10259. Answer: The BDE uses rows effected to determine if an UPDATE is successful. SET NOCOUNT ON tells MSSQL to return 0 for rows effected for all UPDATE statements and thereby causing all UPDATES to fail. 7/28/99 9:07:21 AM
Last Modified: 01-SEP-99