DataLink: Null converted to Zero on Import

3.81K viewsDataLink
0

When I import numeric data that contains a null, the null is converted to a zero when imported by the DataLink.

This is causing problems in fields where zero should be different from null. For instance, I have user “override” fields. A null means the user chooses not to override. A zero means they override with zero (which is different from null in this case).

Is there a way to prevent Quantrix DataLinks from converting null to zero for numbers?

0

Actually – this looks like something that occurs using DataLink against a database… In my test MYSQL database I NULL’d out a couple of values, and I can see the import via DataLink sets them to zero. I will investigate further and advise…

-Mike

You are viewing 1 out of 5 answers, click here to view all answers.