Android Question String Array in SQLite

[tdocs2]

Greetings, all.

Thank you in advance for answering my question.

I have a string array consisting of single characters:

Dim ArrayExample(26) as string

I want to make the array part of a table in SQLite.

How do I save a String Array in SQLite?

Can I just code ArrayExample as TEXT?
or
Do I have to first convert the string array, ArrayExample, to a string using StringBuilder?

Best regards.

Sandy

 

[Douglas Farias]

http://www.b4x.com/android/forum/threads/keyvalues-extended-keyvaluestore.32553/

 

[tdocs2]

http://www.b4x.com/android/forum/threads/keyvalues-extended-keyvaluestore.32553/

Muito obrigado, Douglas.

The solution seems a bit too complicated for my question and is certainly above my expertise level. I just want to store the equivalent of an ASC alphabet, 26 letters, as a field in each record of a table. Converting the array to a string using StringBuilder seems to be a simpler if not elegant solution...

Best regards.

Sandy

 

[LucaMs]

You could use the library ByteConverter and its functions StringFromBytes - StringToBytes.

(But... do you need to save all 26 letters in a field in every record?)

 

[tdocs2]

You could use the library ByteConverter and its functions StringFromBytes - StringToBytes.

(But... do you need to save all 26 letters in a field in every record?)

Ciao, Luca, and thank you for your generous support.

The 26 letters are 26 choices related to each record. What is wrong with:

Sub ArraytoString
Dim ArrayExample(26) As String
Dim sb As StringBuilder
Dim result As String
For i=0 To 25
    ArrayExample(i)=Chr(65+i)
Next
sb.Initialize
For j=0 To 25
    sb.Append(ArrayExample(j))
Next
result=sb.ToString
Log ("Result " & result)
End Sub

The log shows:

Result ABCDEFGHIJKLMNOPQRSTUVWXYZ

Maybe not elegant but it seems to work.

Best regards.

Sandy