Visual Basic 6.0

Swap JSON Objects

See more JSON Examples

Demonstrates how to swap two JSON objects within a JSON document. Visual Basic 6.0

Dim success As Long
success = 0

Dim json As New ChilkatJsonObject
json.EmitCompact = 0

' Load the following JSON:

' {
'   "petter": {
'     "DOB": "26/02/1986",
'     "gender": "male",
'     "country": "US"
'   },
'   "Sara": {
'     "DOB": "13/05/1982",
'     "gender": "female",
'     "country": "FR"
'   },
'   "Jon": {
'     "DOB": "19/03/1984",
'     "gender": "male",
'     "country": "UK"
'   }
' }

success = json.LoadFile("qa_data/json/people.json")
If (success = 0) Then
    Debug.Print json.LastErrorText
    Exit Sub
End If

' Swap the positions of Jon and Sara.
Dim index1 As Long
index1 = json.IndexOf("Jon")
Dim index2 As Long
index2 = json.IndexOf("Sara")
success = json.Swap(index1,index2)

' We have this now:
Debug.Print json.Emit()

' {
'   "petter": {
'     "DOB": "26/02/1986",
'     "gender": "male",
'     "country": "US"
'   },
'   "Jon": {
'     "DOB": "19/03/1984",
'     "gender": "male",
'     "country": "UK"
'   },
'   "Sara": {
'     "DOB": "13/05/1982",
'     "gender": "female",
'     "country": "FR"
'   }
' }

' To swap an inner member:

Dim jsonSara As New ChilkatJsonObject
success = json.ObjectOf2("Sara",jsonSara)

index1 = jsonSara.IndexOf("DOB")
index2 = jsonSara.IndexOf("country")
success = jsonSara.Swap(index1,index2)

' We now have this:
Debug.Print json.Emit()

' {
'   "petter": {
'     "DOB": "26/02/1986",
'     "gender": "male",
'     "country": "US"
'   },
'   "Jon": {
'     "DOB": "19/03/1984",
'     "gender": "male",
'     "country": "UK"
'   },
'   "Sara": {
'     "country": "FR",
'     "gender": "female",
'     "DOB": "13/05/1982"
'   }
' }