SQllite and json export

[padvou]

How can I export data from an SQLlite table to a json file?
Thank you

 

[Erel]

You can use DBUtils module. See ExecuteJSON.

 

[padvou]

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]

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]

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]

There is no 'money' type in SQLite. You should use DB_INTEGER or DB_REAL.

 

[padvou]

Thank you. I 'll try it out and see what happens