Expand my Community achievements bar.

SQLAssembler and Nulls

Avatar

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.

2 Replies

Avatar

Employee

Which version of LCDS are you using?

Avatar

Level 1

We are using LCDS 4.6.1.333593.