I have a question about the correct use of a SQL Assembler destination. It seems that the SQL Assembler does not handle NULLs when data is passed to it from the flex client. If I have a value object with a NULL string attribute, SQL Assembler doesn't seem to recognize that the attribute exists. When performing an update a "Missing IN or OUT parameter at index:: xxx" error appears in the log.
If I change the code to make sure the string attribute in question has an empty string instead of a NULL before being passed to the server, the error goes away.
Is this by design? What is the proper way to handle this?
Which version of LCDS are you using?
We are using LCDS 18.104.22.1683593.