1. Alexis Colon Lugo
  2. as SQLite DB Server
  3. Friday, August 30 2019, 06:39 PM
  4.  Subscribe via email
Hi
Do you have an example of read from sqlite rest and fill ListBox with the data.

i am using iOS_vSQLite_Fast

thanks
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
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.
Comment
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 1
Ivan Smahin Accepted Answer
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".
Comment
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 2
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.