Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 707
  • Last Modified:

Sql server is not committing row

Hi.
I have three tables. Customers with PersonID as identity PK and Functionalities with FunctionalityID as identity PK.
Between them, I have a N:M table with these both keys, as group key.
well, some records, not all, that I try to insert it mannually (with the stored procedure is the same), I got the error:
"This row was successfully committed to the database. However, a problem occurred when attempting to retrieve the data back after the commit. Because of this, the data in this row is read-only. To fix this problem, please re-run the query."
what is wrong? why only some records?

thx in advance.
0
Deraldo Silva
Asked:
Deraldo Silva
  • 4
  • 4
1 Solution
 
ste5anSenior DeveloperCommented:
So, what kind of front-end are you using?
0
 
Deraldo SilvaAuthor Commented:
Sorry.

Microsoft SQL Server Management Studio                                    11.0.5058.0
Microsoft Data Access Components (MDAC)                                    6.3.9600.16384
Microsoft MSXML                                    3.0 4.0 6.0
Microsoft Internet Explorer                                    9.11.9600.17351
Microsoft .NET Framework                                    4.0.30319.34209
Operating System                                    6.3.9600
0
 
ste5anSenior DeveloperCommented:
So you're working in SSMS? Then post a concise and complete example. A screenshot would also be interesting.
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
Deraldo SilvaAuthor Commented:
Ok. attached
problem.pdf
0
 
ste5anSenior DeveloperCommented:
Well, just press the ! button - Query Designer\Execute SQL (Ctrl+R). The edit grid has some limitations.
0
 
Deraldo SilvaAuthor Commented:
yep. I already did it. BUT, when I do that, the record goes away.
0
 
ste5anSenior DeveloperCommented:
So, then use a query to do your update or insert. The grid hiddes the real cause.

btw, sure that there are no triggers on those tables?
0
 
Deraldo SilvaAuthor Commented:
no. there are no triggers.
so, I remove all records and recreate them. it is ok now.
thx
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now