Export CSV

[cnicolapc]

HI,
I have a sql database containing a table "Items"
I would like to export to a CSV file records of the field "Code", "Description".
I tried to create a List and
For i = 0 To Cursor1.RowCount - 1
Cursor1.Position = i
List1.add (Cursor1.GetString ("Code"))
List1.add (Cursor1.GetString ("Description"))
next
Exp.SaveCSV (File.DirDefaultExternal, "test.csv", "," List1)
but there is a Java error.
I definitely missed something in the procedure.
Thanks for the help
Nicola

 

[cnicolapc]

Hi,
I managed with dbUtils, but I'd be happy to succeed even if someone can not explain how.
thanks
Nicola

 

[Erel]

but there is a Java error.

Posting the error message is important to understand the problem.

The list should be made of arrays of strings. Each item represents a row.
You can use ExecuteMemoryTable to get the correct list.