Android Question SQLlite to csv and Dbutils

Tom1s

Member
Licensed User
Longtime User
Hi

I tried this two different ways but no success. With cursor and with dbutils.
In log there is this:
mlist(ArrayList) [[Ljava.lang.String;@42269508]

and the row in the file is full of strange symbols.



B4X:
Dim mlist As List
mlist.Initialize
mlist=DBUtils.ExecuteMemoryTable(SQL1,"Select ID1,ID2,GPSLat,GPSLon FROM table where status=3",Null,0)
Log("mlist" & mlist)
Dim su As StringUtils
su.SaveCSV(File.DirInternal,"marker_data.csv","|",mlist)
 
Last edited:

Tom1s

Member
Licensed User
Longtime User
It looks ok! There was left a row in the file and it tried to owerwrite it. I have to put some clean all or file replace tms.
Now it works.
Thanks
 
Last edited:
Upvote 0
Top