Help with JSON and B4A

[NJDude]

I'm having a little bit of difficulty with B4A and JSON.

I have a simple MySQL database and each record contains 3 fields:

Name, Age and Sex

The result in JSON format is:

{"Name":"Joel","Age":"20","Sex":"M"}

My problem is, I've been unable to figure out how to parse it, I've read the examples posted but, I think I'm having a bad day

Thanks in advance.

 

[Erel]

Have you read the JSON tutorial: http://www.b4x.com/forum/basic4andr...als/6923-android-json-tutorial.html#post39966

Please post your parsing code and the error that you are getting.

 

[NJDude]

Yes, I've read that tutorial but that example has sub items, mine is just a flat or single structure, I'm not sure exactly how to read them using JSON.

 

[dealsmonkey]

Yes, I've read that tutorial but that example has sub items, mine is just a flat or single structure, I'm not sure exactly how to read them using JSON.

Give me a short while and I'll post an example,.

 

[Erel]

Dim JSON As JSONParser
JSON.Initialize(jsonstring)
Dim m As Map
m = JSON.NextObject
Msgbox(m.get("Name"), "")

 

[NJDude]

Thanks, I was adding an extra MAP, now I see how it works.