Problem with Null Values in EasyBadge Database

Modified on Tue, 15 Dec, 2020 at 12:05 PM

 

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

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article