Probably it would be helpful:

http://valentina-db.com/docs/dokuwiki/v9/doku.php?id=valentina:articles:vserver_rest

The only difference is "SQLite" instead of "Valentina" as a "vendor".

Hi Alexis,

No, there is no specific example but you can do it using ParseJSON method from Xojo.

You should modify the method PageReceived of mSQLSocket socket

Dim str As Text



Dim dict As Xojo.Core.Dictionary = Xojo.Data.ParseJSON( Xojo.Core.TextEncoding.UTF8.ConvertDataToText( Content ) )



Dim records() As Auto = dict.Value("records")

Dim values() As Auto



For Each values  In records

  str = str + values(1)

Next

You can replace "str = str + values(1)" with your implementation which fills the list box - values(1) is a value of the second field.