Current Version of SQLlite in Basic4Android

[DKnowles]

Hi Erel & other experts

Just started porting one of our apps from windows to android and reviewing how we update the database from the web site, thinking of actually downloading the data as a SQlite file and let the phone then interrogating this, but need to know what version of SQLlite basic4Android is using so I can install the right ODBC version on the server.

Might work might not? but worth a try.

David

 

[Erel]

The SQLite engine is part of Android. The actual version depends on the Android version.
It is 3.4 or above: database - Version of SQLite used in Android? - Stack Overflow

 

[DKnowles]

Thanks

Thanks Erel, will try and update the post with the result.

ps if anyone wondering why I want to do it this way I'm a SQL Programmer at heart so think in SQL then translate to basic and if I can miss XML or custom text data on the way all the better.

David

 

[nacnud]

Old now I know, but if you use

"SELECT sqlite_version()"

and SQL.ExecQuerySingleResult

I think you should get back a good idea of the version of SQLite installed on the device.

Cheers,
Dunk