Symptoms
Filtering Error when using a Stored Procedure SmartObject
We have just upgraded our Development Environment to the new 4.6.9 version and have encountered an error that effects almost every application we have built.
When we apply any filter (bit, string, etc.) on a dropdown list we receive an error like, "Must declare the scalar variable "@filterParamValue140f98773518e4666b4d05c7042e1024dORDER"." (See Filter Error.docx)
When we remove the filter we no longer receive the error but we require the filter. (See Examples of filters.docx)
We need a fix ASAP as we can no longer work in a productive fashion.
Diagnoses
This is a known issue with 4.6.9
Resolution
Labs has provided Coldfix and that resolved the issue.