2 Replies Latest reply on Apr 19, 2013 7:09 AM by jamatbls

    SQLAssembler and Nulls

    jamatbls Level 1

      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?

       

      thanks.