Android Question Strange behavior of null value returned from database

[MrKim]

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:

Set to B4A Null:

Set to Null returned by database/driver:

 

[RB Smissaert]

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

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

RBS

 

[Mahares]

You can probably use the ifnull function:

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,

 

[MrKim]

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

RBS

Good Idea. Out of habit I try to keep server side processing to a minimum and do busy work like this on the WS/tablet where there is plenty of spare CPU power but in this case probably not.

You can probably use the ifnull function:

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,

in TSQL it is IsNull, not IfNull but as with Coalesce, also a good idea, thanks.