This article is for when an external connection is set up within EasyBadge and the source database can allow null values but EasyBadge cannot.
When you add a field that can be NULL is causes problems if the receiving side cannot (or doesn’t want to) process them. You can use the coalesce function to get around this. This function is used within the SQL query used i the external connection.
So instead of
Select DATEOFBIRTH from ….
You can use
Select coalesce(DATEOFBIRTH,’’) as DATEOFBIRTH from
What coalesce does is if the first argument is NULL it gives the second. If the second is NULL it will give the third etc.
Another method
IsNull(Qualification,'') as Qualification
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article