D DKnowles Member Licensed User Longtime User Apr 14, 2011 #1 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
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 B4X founder Staff member Licensed User Longtime User Apr 14, 2011 #2 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 Upvote 0
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
D DKnowles Member Licensed User Longtime User Apr 14, 2011 #3 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 Upvote 0
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
N nacnud Member Licensed User Longtime User Jul 28, 2011 #4 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 Upvote 0
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
