Consultor Eletrônico

Status: Unverified

SYMPTOM(s):

Records Not Being Updated As Expected

FOR EACH loop searches through records for two dates that do not match. When found the first date is set to be the same as the second however, on rerunning the query and expecting all records to have been fixed there are still the same number of records needing updated

CAUSE:

The problem was that the assign of the date field meant that on the next iteration of the loop there was a new date comparison so it was not possible to complete the update of all records using this coding style

FIX:

Change the query to stop iterating like this