PeopleCode FieldChange SQLEXEC Not Updating

Hi Everyone,

I have never experienced this before. In FieldChange event of Record PeopleCode, I have a while loop and inside the while loop I am updating a table with SQLEXEC.

If the SQL Fetch of While loop retrieves one row, the Update SQLEXEC in the while loop updates the table. If the SQL Fetch of the while loop retrieves more than one row, the Update SQLEXEC does run for each retrieved row, but does not update the table.

I put messageboxes and do see every value and everything is how it should be. When it didn't work, I even tried getting a return value from the SQLEXEC command and the returned value is "True" which means the SQL command executed successfully, but it somehow doesn't commit or affect the database table.