title: Powerbuilder application throws error : Row changed between retrieve and update
body: <p>We have application developed using PowerBuilder 6.0(Ingres as an backend). Application code was never updated since 2009. However suddenly it starts showing update error.  Users are getting error message like '<strong>Row Changes between retrieve and update</strong>' on attempt to save data. We have confirmed that original data is not even changed under database by any one during user’s attempt to save.</p>
  
  <p>Application shows following error message.</p>
  
  <p><strong>Error message</strong></p>
  
  <p><strong>Update failed.</strong></p>
  
  <p><strong>Database error: -3: Row changed between retrieve and update.</strong></p>
  
  <p><strong>No changes made to database.</strong></p>
  
  <p><strong>Update os_sec1 set encrpt_pw='XXXXX' WHERE user_id ='Q0001   ' and USER_DEC = 'Mayur Patel_<em>_</em>__<em>_</em>__<em>_</em>__' and last_pw_change = {ts'2012-03-12 13:27:28'}</strong></p>
  
  <p>We just noticed update statement's where cause have wrong values. [User Desc] field is showing value with extra space. We figure out that [User Decs] field having 40 char length and update statement showing total 40 char (Values + empty space). We do not know how application start considering extra space.</p>
  
  <p>Other surprising part is, for some users application is working and for other it is showing error. Also all users are using Window 7. </p>
  
  <p>Anyone have idea what could be the reason? Appreciate all inputs. </p>