B4J Question DBUtils And operator

[Subatanx86]

Is it possible to use the And operator to set two conditions for WhereFields that must be true to update a DBUtils record? I'm sure I'm wording this poorly. Below is an example of what I want to do, but it obviously doesn't work.

Dim WhereFields As Map
    WhereFields.Initialize
    WhereFields.Put("Badge", txtBadge.text) AND WhereFields.Put("Status", "out")
    DBUtils.UpdateRecord(sql1, "People", "DateOut", DateTime.Date(DateTime.Now), WhereFields)

 

[OliverA]

The WhereFields are ANDed

Dim WhereFields As Map
WhereFields.Initialize
WhereFields.Put("Badge", txtBadge.text)
WhereFields.Put("Status", "out")
DBUtils.UpdateRecord(sql1, "People", "DateOut", DateTime.Date(DateTime.Now), WhereFields)

The update will only happen on records where Badge = txtBadge.text AND Status = "out"

 

[Subatanx86]

The WhereFields are ANDed

Dim WhereFields As Map
WhereFields.Initialize
WhereFields.Put("Badge", txtBadge.text)
WhereFields.Put("Status", "out")
DBUtils.UpdateRecord(sql1, "People", "DateOut", DateTime.Date(DateTime.Now), WhereFields)

The update will only happen on records where Badge = txtBadge.text AND Status = "out"

Interesting I'm not getting the results I'm expecting. I'll look to see if I made an error somewhere else.

 

[Subatanx86]

Confirmed I made a dumb typo. It does work. Thanks for the help.

 

[Erel]

Tip:

DBUtils.UpdateRecord(sql1, "People", "DateOut", DateTime.Date(DateTime.Now), CreateMap("Badge": txtBadge.Text, "Status": "out"))