problem in update query!

Question

I had written a query like this

  string strUpdateQuery = "UPDATE M_QA SET ANSWER = '" + txtEditorAnswer.Text.Trim().Replace("'", "''")
                                      + "', UPDATED_ON = getDate(), UPDATED_BY = '" + this.Session["UserId"].ToString()
                                      + "' WHERE PK_ID = " + _currentQuestionId + " AND IS_ACTIVE = 1";

but the value doesn't get updated untill i put a breakpoint at this query.

Can anyone please help me..

You will have to show a bit more code than that...

Adriaan Stander
– Adriaan Stander

2010-10-13 04:47:52 +00:00
Commented Oct 13, 2010 at 4:47 — Adriaan Stander
– Adriaan Stander, Commented Oct 13, 2010 at 4:47
as it stands, question makes no sense...

Mitch Wheat
– Mitch Wheat

2010-10-13 04:47:54 +00:00
Commented Oct 13, 2010 at 4:47 — Mitch Wheat
– Mitch Wheat, Commented Oct 13, 2010 at 4:47

Thomas · Accepted Answer · 2010-10-13 04:55:01Z

1

You should be using a library to assemble your SQL statements rather than direct concatenation.
What does SQL Profiler show as the query being passed to the server?
If I had to wager a guess, I would say that either the question with the given primary key does not exist at the time the query is executed or the question is not yet active at the time the query is executed. Either way, you need to verify the exact query that is actually being passed to the server (via SQL Trace/Profiler) and you need to verify that the primary key value actually exists at the time the query is executed and that the question is actually marked as active.

answered Oct 13, 2010 at 4:55

Thomas

64.8k12 gold badges98 silver badges142 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

problem in update query!

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related