Android Question Help With Saving Database To Html File

[Uederson Ferreira]

Hi again, friends!
How are you all?
I need to save sql database data as an html file.
By the experience I have with another BASIC like language, I'm using something like this:

lista.AddAll(Array As String("<html>","<head>","<body>","<table>","<thead>","<thead>","<th>Data</th><th>Column1</th><th>Column2</th><th>Column3</th><th>Column3</th></thead>","<tbody>"))

cursor = Starter.SQL1.ExecQuery("SELECT * FROM records")
For i = 0 To cursor.RowCount - 1
    cursor.Position = i

    lista.Add("<tr><td>"&cursor.GetString("date")&"</td>")
    lista.Add("<td>"&cursor.GetString("services")&"</td>")
    lista.Add("<td>"&cursor.GetString("input")&"</td>")
    lista.Add("<td>"&cursor.GetString("output")&"</td>")
    lista.Add("<td>"&cursor.GetString("values")&"</td></tr>")
Next
cursor.Close

lista.AddAll(Array As String("</table>","</body>","</html>"))
File.WriteList(File.DirRootExternal, "page.html", lista)

It is working fine, but I would like to know if there is another better way of do it.

Another question: in the other BASIC like language I use, I can do

variable = "<html>"
variable += "<head>"

then I think my code would be something like this (only a example):

page = "<html>"&CRLF&"<head>"&CRLF&"<body>"&CRLF&"<table>"&CRLF&"<thead>"&CRLF&"<thead>"& _
"<th>Column1</th><th>Column2</th><th>Column3</th><th>Column3</th></thead>"&CRLF&"<tbody>"

cursor = Starter.SQL1.ExecQuery("SELECT * FROM records")
For i = 0 To cursor.RowCount - 1
    cursor.Position = i

    page += "<tr><td>"&cursor.GetString("date")&"</td>"& _
    "<td>"&cursor.GetString("services")&"</td>"& _
    "<td>"&cursor.GetString("input")&"</td>"& _
    "<td>"&cursor.GetString("output")&"</td>"& _
    "<td>"&cursor.GetString("values")&"</td></tr>"
Next
cursor.Close

File.WriteString(File.DirDefaultExternal,"page.html",page)

The question is: is there some equivalent way of doing the same with B4X strings?

Thank you in advance, friends!

Cheers
Uederson

 

[fixit30]

DBUtils 2 has an ExecuteHTML option. Maybe it can help you?

Also B4A equivalent:

variable = "<html>"
variable = variable & "<head>"

 

[Uederson Ferreira]

Thank you so much, friend!
I will check DBUtils 2.

Cheers