Android Question Strange behavior of null value returned from database

MrKim said:

I am trying to figure out how to get consistent results from Null. jtds database driver returns something "sort of like" null - but different. I just need to consistently test for null.
See results below:

ActiveEmp.PassWord has been initialized:
View attachment 80291
Set to B4A Null:
View attachment 80292

Set to Null returned by database/driver:
View attachment 80293

Click to expand...

RB Smissaert said:

Can you show the SQL that gets the data into Crsr?
Are you aware of the coalesce function?

RBS

Click to expand...

Mahares said:

You can probably use the ifnull function:

B4X:

ActiveEmp.Password =Starter.SQL1.ExecQuerySingleResult2("SELECT ifnull(Emp_BadgeNum,'') FROM mytable WHERE user LIKE ?", _
    Array As String("%MrKim%"))  'note 2 single quotes after Emp_BadgeNum,

Click to expand...