In response to the recently posted tech note "T37-2013: Potential for incorrect data on SQL Insert and SQL Update when parameter mapping is used in Pipeline Pilot 8.x, 9.0 and AEP 9.0," I have create the attached example protocol showing how to detect a change in property type using a hash table. In this implementation an error will be thrown, but it can be easily modified to instead throw a Debug Message or to set a variable to cause the commit to fail in the SQL components.

Ian Kerman

Platform Support