Current Version of SQLlite in Basic4Android

D

DKnowles

Member
Licensed User
Longtime User
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
 
Sort by date Sort by votes
D

DKnowles

Member
Licensed User
Longtime User
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
N

nacnud

Member
Licensed User
Longtime User
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
You must log in or register to reply here.

Similar Threads

  • Article
Share My Creation BasicIDE Suite 4 - Now even further improved
Replies
11
Views
9K
tech2k
T
  • Locked
  • Article
Android Tutorial Background location tracking
Replies
15
Views
51K
Erel
  • Locked
  • Article
B4A Library [class] FileProvider - share files
2
Replies
22
Views
59K
Erel
  • Locked
  • Article
Android Tutorial GUI SDK Manager for newer versions of Android tools
4 5 6
Replies
105
Views
139K
lemonisdead
  • Question
Other Basic4android v3.20 is released
2 3
Replies
55
Views
61K
Erel
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…