Android Question Create a .txt file from a database

[MarcioCC]

Good evening, I have a table named PRODUCTS created in sqllite, how do I export the data from this table to a .txt file and then download this .txt file to a server via usb cable.

The table has the fields:

CODBARRA PRIMARY KEY
QTDE

(S.ExecNonQuery2 ("INSERT INTO PRODUCTS (rowid, CODBARRAS, QUANTITY) VALUES (NULL,?,?)", Array As String (Edtdescr.Text, EdtQtde.Text))

C = s.ExecQuery ("SELECT CODBARRAS, QUANTITY FROM PRODUCTS ORDER BY CODBARRAS")

Lvadiciona.AddTwoLinesAndBitmap (C.GetString ("CODBARRAS"), C.GetString ("QUANTITY"), LoadBitmap (File.DirAssets, "ICONE LIXEIRA2.jpg"))


Does anyone have an example how do I do this ??

 

[mangojack]

please use code tags ... [code]insert code here ...[/code]

 

[Erel]

You can use DBUtils.ExecuteJSON to generate a JSON string from the query result.

 

[MarcioCC]

Erel , How can you send me an example is the first time i'm going to make this kind of code

 

[eps]

What are you going to do with the data once you've exported it?

Usually you try and export to a CSV (Comma Separated Variable) file which can be re-imported in to a database, edited in Excel or similar or a text editor.

ETA : for instance https://www.b4x.com/android/forum/threads/export-sql-to-csv.16901/#post-96621

 

[MarcioCC]

Good morning, friend, it's going to work like this.
I will capture the data by cell phone save this data in my table (PRODUCTS) and export to a .txt .xls or csv file and send it to a server, where on that server has an ERP automation system where they will import this data.

 

[fixit30]

To save the data to a csv file use DBUtils.ExecuteMemoryTable to return your query as a List, then use StringUtils.SaveCSV to save to a csv file.