B4J Code Snippet [BANano]: Sharing the goodness

Mashiane

Expert
Licensed User
BANanoSQL: Query a JSON array quicky.

B4X:
'convert json string to list
Dim fldJSON as List = BANano.FromJSON(strJson)
'open the database
db.OpenWait("bvmdesigner", "bvmdesigner")
'execute the query
Dim rslt As List = db.ExecuteWait("select * from ? where colactive = 'Yes'", Array(fldJSON))
 Log(rslt)
 
Top