Convert a sqlite table to a series of strings

Getting Started
1

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?

Thanks!

2

that should be a simple task
post what you are doing…
you should be able to convert a recordset entry to a string in a sub-fraction of a second

s=""
for i=1 to rs.fieldcount
s=s+rs.indxfield(i).stringvalue
next i
myarray.append s

THAT IS JUST TO PROVIDE AN IDEA… NOT A CUT/PASTE SOLUTION

3

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

4

@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 :smiley:

@Antonio Rinaldi Grandissimo, proprio quello che cercavo :smiley: That’s the ticket :slight_smile: