Hey all I am trying to get this
SQlite query to work in my
Android app but for some reason its giving me the error of:
no such function: json_object (code 1): , while compiling
But it works in my
DB Browser when I run the query?
My query is this:
And the output is:
[{"name":"lr","ip":"192.168.1.0","mac":"00:00:00:00","token":"na"},
{"name":"mbr","ip":"192.168.1.0","mac":"00:00:00:00","token":"na"},
{"name":"jr","ip":"192.168.1.0","mac":"00:00:00:00","token":"na"},
{"name":"tr","ip":"192.168.1.0","mac":"00:00:00:00","token":"na"},
{"name":"dsr","ip":"192.168.1.0","mac":"00:00:00:00","token":"na"},
{"name":"lr2","ip":"192.168.1.0","mac":"00:00:00:00","token":"na"},
{"name":"lr","ip":"192.168.1.0","mac":"00:00:00:00","token":"na"}]
Putting that query into my Android app:
The error shows up when on the
db.rawQuery line.
Does Androids SQlite not have support for
json_group_array/json_object?