Android Question [SOLVED] DButils - Doub about it

killiak said:

Is there any option to see what tables are inside my database?

Click to expand...

Cursor1 = SQL1.ExecQuery("SELECT name FROM sqlite_master WHERE type='table'")
For i=0 To Cursor1.RowCount-1
        Cursor1.Position=i
        Log($"Table: ${i}  ${Cursor1.GetString("name")}"$)  'displays all tables in database
Next

Mahares said:

Use this code to display all your tables:

B4X:

Cursor1 = SQL1.ExecQuery("SELECT name FROM sqlite_master WHERE type='table'")
For i=0 To Cursor1.RowCount-1
        Cursor1.Position=i
        Log($"Table: ${i}  ${Cursor1.GetString("name")}"$)  'displays all tables in database
Next

Click to expand...

Erel said:

Dim rs As ResultSet = SQL1.ExecQuery("SELECT name FROM sqlite_master WHERE type='table'")
Do While rs.NextRow
Log($"Table: ${Cursor1.GetString("name")}"$) 'displays all tables in database
Next
rs.Close

Click to expand...

Dim i As Int
    Dim rs As ResultSet = SQL1.ExecQuery("SELECT name FROM sqlite_master WHERE type='table'")
    Do While rs.NextRow
        Log($"Table:${i}    ${rs.GetString("name")}"$)  'displays all tables in database 
        i=i+1
    Loop
    rs.Close

 Dim rs As ResultSet = SQL1.ExecQuery2("SELECT name FROM sqlite_master WHERE type=?", _
   Array As String("table"))

Mahares said:

@Erel is so excited about publishing the latest B4A 7.80 that he uncharacteristically stumbled through his answer which should be;

Click to expand...

Erel said:

Only half true
I didn't miss the index. It makes the solution less elegant and I don't think that the index adds anything useful here.

Click to expand...