I am trying to make a SQL Update Statement using the Connector (Dynamic Update) with some fields having NULL value.
However, it doesn't seem to work. When i check my Database afterwards, i see that the NULL value is saved as string in that columns. How can i do that?
The generated update script looks something like this:
DBSTART|f51a33f3-b2d6-44e8-a859-305f5aa69120|2|@|BEGIN|2|@|OUT_START|3|@|12345|^|NULL|^|NULL|^||^|NULL|^|19710101 000000.000|^||^|NULL|^||^||^|NULL|^|Name|^||^|50|^|NULL|^|NULL|^|eng|^|NULL|^|NULL|^||^|NULL|^|NULL|^|Male|^|Something|^|AG|^||^||^|Something|^|NULL|^|Something|^||^||^||^||^|ACTIVE|^|100200562|^|city 1234|^|GU|^|NULL|^|NULL|^|NULL|^|NULL|^|NULL|^|NULL|^|NULL|^|NULL|^|NULL|^|2000|^||^|100200562|#||#|OUT_END|3|@|END|2|@|DBEND|f51a33f3-b2d6-44e8-a859-305f5aa69120|2|@|
I've seen that someone had similar problem, but i'm asking if it is possible in another way (using the dynamic update)?