title: SQL UPDATE Statement Hangs Powerbuilder
body: <p>As the title says, I have a seemingly simple embedded SQL Update statement in my code that hangs Powerbuilder 12.5.</p>
  
  <pre><code>UPDATE COMMENTS SET comment_text = :strNewComment
  WHERE ID = :lngID;
  </code></pre>
  
  <p>I've looked at the code in debug; all variables have valid values and execution stops exactly on that SQL statement. </p>
  
  <p>The only 'theory' I have why this might be happening is that there might be a locking issue as the same data is open in a datawindow, but I'm not enough of a PB expert to know if it is.</p>
  
  <p>A little background info around this scenario: A datawindow grid displays a list of comments. User selects a comment row, clicks an 'Edit' button and its click event fires. A modal window displays with the comment text in a textbox. User edits comment text, clicks OK button. Click event continues, running the above sql statement and then refreshing the datawindow with a Retrieve() call.</p>