Hi,
I want to export a whole sqlite table to an array of strings(one string for each table row), right now I am parsing each and every cell in a recordset into a string using recordset.fields(“Column”).StringValue and concatenating all the values into a single string. As per 2017r1 trying to touch the row of code where i merge all of 115 columns hardlock the ide, so i hoped there was a better solution. Help?
dim rows() as string
while not rs.eof
dim r() as string
for i as integer=1 to rs.fieldCount
r.append rs.idxField(i).stringValue
next
rows.append join(r, “”)
rs.moveNext
wend
@Dave S
I am using a sqlite db to provide a storage space for historical readings of a device, data checks in fine, now i want to check out into a text file. Using bruteforce i can get it to work(barely) but xojo seems to not be enjoying having the string being build on a 5850 digits comination of x1 + “;” + x2 + “;” + xn
@Antonio Rinaldi Grandissimo, proprio quello che cercavo That’s the ticket