Android Question DBUtils.ExecuteMap and Null

[Frank Cazabon]

Hi,

I have this code:

    Dim del As Map
    del = DBUtils.ExecuteMap(SQLLite, "SELECT del_pk FROM DeliveryHistory WHERE del_rndfk = ? AND del_scancode = 1", Array As String(rndpk))

    If del = Null Then
        lblStatus.Visible = False
        btnLoad.Visible = True
    Else
        lblStatus.Visible = True
        btnLoad.Visible = False
    End If

Even though I have stepped through the DBUtils code and see "return Null" executing when cur.RowCount = 0, my variable test for del = Null is always False!

How can this be?

 

[Erel]

This is related for Map being a wrapper for another object.
It is safest to check:

If del = Null Or del.IsInitialized = False Then

 

[Frank Cazabon]

Thanks. I was following the DBUtils example, maybe that could be updated to reflect this too?

 

[Erel]

Did it fix your issue?

 

[Frank Cazabon]

Erel, yes, that solved my issue. Thanks again.