sqlite db - field's type

[henry1311]

Hi,
How do I know the type of the field present in a sqlite database?


Es :
create table table1 (col1 TEXT, col2 INTEGER, col3 TEXT)

Sub LogTable1
Dim Cursor1 As Cursor
Cursor1 = SQL1.ExecQuery("SELECT col1, col2, col3 FROM table1")
For i = 0 To Cursor1.RowCount - 1
Cursor1.Position = i
Log(Cursor1.GetString("col1")) <--- type ? (TEXT)
Log(Cursor1.GetString("col2")) <--- type ? (INTEGER)
Log(Cursor1.GetString("col3")) <--- type ? (TEXT)
Next
Cursor1.Close
End Sub

Thanks
Enrico

 

[Erel]

There is a special query which you can use to find the types.
The SQLite Viewer uses it: Android SQLite Viewer

 

[henry1311]

Thank you Erel
Ciao!
Enrico