Android Question Saving LIST from ExecuteMemoryTable

[tcgoh]

Hi,

I am trying to save a File.writelist from DBUtils.ExecuteMemoryTable but the results are

[Ljava.lang.string;@43dld538
.........

What am doing wrong with these codes

Dim list as List

list = DBUtils.ExecuteMemoryTable(SQL,"SELECT name FROM table1", Null,0)
        File.WriteList(File.DirRootExternal,"sqllist.txt",list)

Thanks for helping

 

[LucaMs]

First of all, change the variable name "list" to "lstNames", for example (also "table1"...!)

Then, try to open "sqllist.txt" ("lstNames.txt" could be better) because it should be right.

 

[tcgoh]

Yes the Dim Listname as list has been changed.

Opening the txt file give me the same results...
[Ljava.lang.string;@43dld538
.........

 

[LucaMs]

Opening or ... using log(lstNames)?

 

[tcgoh]

same results
[Ljava.lang.string;@43dld538
.........

The codes is not right! not the naming I think

 

[LucaMs]

#Region "ExecuteMemoryTable"
'Executes the query and returns the result as a list of arrays.
'Each item in the list is a strings array.


Sorry, I had forgotten that function.

It returns a list but each element of the list is a list that is a record.

 

[Erel]

You are trying to save a list of arrays in a text file. It will not work like this. The simplest solution is to use RandomAccessFile.WriteObject (or KeyValueStore class).