| SET NOCOUNT ON causes Couldn't perform the edit because another user changed the record error |
|
|
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 0259. 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:2 AM
|
| Hits/month | 2,500,000+ |
| Downloads (Since May 2000) |
7,393,709 |
| Total Files | 6,023 |
| Forum msgs | 7,670 |
| Articles/FAQs | 70+/900+ |
| Kylix |
| Tips n Tricks |
| FAQs |
| Knowledge Base |
| Bug Listings |
| Articles |
| Books |
| Newsgroups |
| Links |
| Submissions |
| Testimonials |
| Advertising |
| Contact Us |
| About Us |
Comments/Problems: Webmaster@delphi32.com
Copyright © 1998-2006, Delphi32.com. All rights reserved.
Terms of Use