padvou Active Member Licensed User Longtime User Nov 12, 2012 #1 How can I export data from an SQLlite table to a json file? Thank you
Erel B4X founder Staff member Licensed User Longtime User Nov 12, 2012 #2 You can use DBUtils module. See ExecuteJSON. Upvote 0
padvou Active Member Licensed User Longtime User Nov 12, 2012 #3 Thank you, I was just looking into dbutils. Hopefully I 'll make do what i want. My next question was about the Array as string() parameter. It takes integer, text, real values. What if i have money? Thank you. Upvote 0
Thank you, I was just looking into dbutils. Hopefully I 'll make do what i want. My next question was about the Array as string() parameter. It takes integer, text, real values. What if i have money? Thank you.
Erel B4X founder Staff member Licensed User Longtime User Nov 12, 2012 #4 Note that it is better to start a new thread for a new question. Which Array As String? What is the data type of this value? Upvote 0
Note that it is better to start a new thread for a new question. Which Array As String? What is the data type of this value?
padvou Active Member Licensed User Longtime User Nov 12, 2012 #5 ExecuteJSON (SQL As SQL, Query As String, StringArgs() As String, Limit As Int, DBTypes As List) I meant DBTypes as list, sorry if that wasn't clear. Upvote 0
ExecuteJSON (SQL As SQL, Query As String, StringArgs() As String, Limit As Int, DBTypes As List) I meant DBTypes as list, sorry if that wasn't clear.
Erel B4X founder Staff member Licensed User Longtime User Nov 12, 2012 #6 There is no 'money' type in SQLite. You should use DB_INTEGER or DB_REAL. Upvote 0
padvou Active Member Licensed User Longtime User Nov 12, 2012 #7 Thank you. I 'll try it out and see what happens Upvote 0
