Android Question How To Determine The SQLite Version Of a Device

Mahares

Expert
Licensed User
Longtime User
I tried to translate this to B4A, but was unable to:
Cursor cursor = SQLiteDatabase.openOrCreateDatabase(":memory:", null).rawQuery("select sqlite_version() AS sqlite_version", null);String sqliteVersion = "";while(cursor.moveToNext()){ sqliteVersion += cursor.getString(0);}

EDIT: I think I got it this time. This seems to work:
B4X:
SQL1.Initialize("","",False)
    Cursor1=SQL1.ExecQuery( "SELECT SQLite_version() as sqliteversion")
    Cursor1.Position=0
    Log(Cursor1.GetString("sqliteversion"))    'displays: 3.7.11 on my device

Thank you
 
Last edited:
Top