I have a Sharepoint list that track sales opportunities. I linked the list to an Access 2010 database so that I could run validation checks against the data. If my validation process finds an error I update the Sharepoint list with an error message. A sharepoint workflow then runs to send an email message to the owner of the opportunity. The next time the process runs if the error has been corrected I clear out the error message columns on the sharepoint list. This is where I'm getting some very strange behavior. The update sets three column values but in addition to those three columns all of my multiline text columns are cleared.
Has anyone seen something like this before?
Before/After images of data
Image of the list definition
sales_opportunity_sp.[Message] = Null,
sales_opportunity_sp.[Message Sent] = -1,
sales_opportunity_sp.[Message Sent Count] = 0
WHERE sales_opportunity_sp.ID = 857;